What is the best way to test T-SQL stored procedures?

sql server Poland
  • 14 years ago

    Hi,


    what is the best way to test T-SQL stored procedures?
    Do You use some special tools for this task?

     

    Wojtek

  • 14 years ago

    hi,

    You can user Query Analyzer to test Procedures.

    Have a fun.

     

     

  • 14 years ago
    In SQL Query Analyzer,

    use EXEC to execute stored procedure

    Ex: EXEC sp_helptext(......)







Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Nine people can't make a baby in a month.” - Fred Brooks