Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-22 : 10:08:28
|
| Steve writes "Hello,Im in the process of testing stored procedures output and Im curious if there is easy way to verify the output. Im trying to write output sql statement that will test the stored procedure.Any clues, tool or short cuts exist? Thanks" |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-01-22 : 10:14:26
|
| You can use query analyzer to get output. It will return all select statements to the results window. You can also test your output variables by using either a select or print statement.Other options are to watch the SPROC inside profiler. You can see values going in and out there. |
 |
|
|
Da_Retina
Posting Yak Master
109 Posts |
Posted - 2002-01-23 : 01:36:43
|
| Another way I find useful is to write to ECHO to a file using xp_cmdshell or maybe use the TSQL debugger if U r using VB..its installation is a headache but it is useful when it is up and running..U can debug Stored Procedures statement by statement!Salute... |
|
|
|
|
|
|
Testing Stored Procedures