sql server - Avoid returning result set from stored procedure -


assume have stored procedure (and can't change it) returning result set:

create procedure test_procedure begin      select 1  end 

i know can insert result set table, hidden calling code:

declare @t table(i int)  insert @t exec test_procedure 

are there other ways hide returning result set calling code?

updated

it looks i've been bit confusing. i'm looking t-sql answers (not .net ones).

no, there no other solution. however, should refactor procedure need. if need output other calls, try split procedure two.


Comments

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

c++ - How do I get a multi line tooltip in MFC -

unit testing - How to mock PreferenceManager in Android? -