This can improve performance by reducing network traffic slightly. ![]() When you use SET NOCOUNT ON, this message is not sent. Whenever you execute a query, a short message is returned to the client with the number of rows that are affected by that T-SQL statement. ![]() ![]() SQL Prompt implements two static code analysis rules to check code for potential misuse of the SET NOCOUNT command:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |