[SQL Server] SET NOCOUNT=ON For Improve Performance in Store Prodedure and Trigger
What is a SET NOCOUNT ON In SQL Server, SET NOCOUNT ON can improve the performance of stored procedures and triggers (In some scenarios) ,In SQL Server SET NOCOUNT ON is used for From Microsoft DocumentationSET NOCOUNT ON prevents the sending of DONEINPROC messages to the client for each statement in a stored…