Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Experts,
The results for both versions are the same, when the procedure is called via SQL Management Studio.
According to SQL Profiler both versions are called in the exact same way.
Thank you very much in advance for explanations.
Try
SET NOCOUNT ON
inside your procedure
Or:
CREATE TABLE #tmptab (ID int)
insert into #tmptab(ID)
select 1 as ID
select ID from #tmptab
DROP TABLE #tmptab
Thank you very much. - The NOCOUNT does the trick...