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 |
|
adlo
Posting Yak Master
108 Posts |
 Posted - 2010-04-28 : 16:47:18
|
| I have a stored procedure that has two execute commands in it.Both select something and do an output.I only want my last exec statement to output results.the problem is the exec statement is causing problems with my application as the application picks up its select output.Is there a way to turn off row results just like nocount it turned off? |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-04-28 : 16:55:15
|
| You can simple comment the execcute statement which you dont want.example /*My first execute statement*/PBUH |
 |
|
|
adlo
Posting Yak Master
108 Posts |
Posted - 2010-04-28 : 17:03:48
|
| resolved it.Put set NOEXEC ON before and set NOEXEC after |
|
|
|
|
|
|
Is it possible to turn off row output?