Product articles
SQL Prompt
Database Testing

  • SQL Prompt
  • Exploring and Refactoring Databases
  • Database Testing

How to Test SQL Server Functions and Procedures using SQL Prompt

Phil Factor shows how to create a table of input values versus expected results, and then use it to unit test your SQL stored procedures and functions and verify that they always produce the correct results. He uses SQL Prompt to make this task much simpler. Read more

Products

  • SQL Change Automation
  • SQL Clone
  • SQL Compare
  • SQL Data Compare
  • SQL Data Generator
  • SQL Prompt
  • SQL Provision
  • SQL Test
  • SQL Toolbelt
  • SQL Toolbelt Essentials

Filter by level

Redgate Hub

  • Product Articles

    Product Articles

    Tips and how-to guides for Redgate products

  • University

    University

    Easy to follow video courses

  • Events

    Events

    Join us online, or get sponsored

  • Forums

    Forums

    Ask, discuss, and solve questions about Redgate's tools

  • Community

    Community

    Develop your skills and meet Redgate Advocates and Friends

  • Simple Talk

    Simple Talk

    In-depth articles and opinion from Redgate's technical journal