2014. 1. 3. 12:22
Does SET NOCOUNT ON eliminate @@ROWCOUNT values after table inserts?
Nope, SET NOCOUNT doesn't interfere with @@ROWCOUNT.
SET NOCOUNT is used to control message returned SQL server to client , it is not just for inserts alone, even for other DML statements as well.
'메모' 카테고리의 다른 글
Create a Dynamic Pie Chart in SharePoint using JQuery & Google Chart API (0) | 2014.01.08 |
---|---|
IIS Session Timeout vs ASP.NET Session Timeout (0) | 2014.01.06 |
[MS-SQL] Group By 없이 Count() 쓰기 (0) | 2013.12.30 |
[자바스크립트] 페이지 리로드 (0) | 2013.12.30 |
sk 와이브로는 무지싸다. (0) | 2013.12.26 |