SQL SERVER – SET Nocount ON

SQL SERVER – SET Nocount ON

When a query executes in sql server, it automatically calculates the count of the data which it return. This is really an overhead for Sql server in case of returning large result set. To improve the performance of the query, we can use SET Nocount ON.

Look at the below example.

Example For SET NOCOUNT OFF

Example For SET NOCount ON

SET NoCount ON Example