How to Execute Stored Procedure with no select in SQL Server 2005?
I am using about 10 stored procedures inside a cursor. While I run my sursor the sp's are executed and some sps contain select statement as well as DML operations too. I dont want that select statement to show. I want to execute only DML operations. That's enough. Is there any way ? your Response is highly ap开发者_开发问答preciated !
No, you can't do this.
The stored procedure is written to SELECT and return data. So it does.
精彩评论