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 - 2005-08-15 : 07:40:48
|
| robert writes "Hi, i want to avoid the result set coming from a precedure.Example:declare @a int, @b varchar(100) SELECT @b = 'select 1' exec (@b)endwhen i execute the above block its showing output 1. And when i call this procedure from VB.NET, its returning 1 as result set.I want to restrict the procedure from returning results from SELECT statementIs there any way to restrict the output from a SELECT query.Thanks in advance.Robert" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-08-15 : 07:42:07
|
| You are running some code, and it's returning what you ran.Maybe, don't run the code ?Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
 |
|
|
|
|
|
restricting output from stored procedure