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

• • Reply

  14 years ago

  by woojtii

  Wojtek

  , Poland

  Joined 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
  
  

  Report abuse
• • Reply

  14 years ago

  by Dharmraj

  Dharmraj Chudasama

  , India

  Joined 14 years ago

  hi,

  You can user Query Analyzer to test Procedures.

  Have a fun.

   

   

  Report abuse
• • Reply

  14 years ago

  by rsgovar

  Govarthanan

  Chennai, India, India

  Joined 14 years ago
  In SQL Query Analyzer,
  
  use EXEC to execute stored procedure
  
  Ex: EXEC sp_helptext(......)
  
  
  
  
  
  
  
  
  Report abuse