By default, NOCOUNT is set to OFF and it returns number of records got affected whenever the command is getting executed. If the user doesn’t want to display the number of records affected, it can be explicitly set to ON- (SET NOCOUNT ON).
Subscribe to:
Post Comments (Atom)
Search This Blog
DAX - Grouping on multiple columns and the count
Please go thorugh the below URL for entire soultion. http://community.powerbi.com/t5/Desktop/DAX-Grouping-on-multiple-columns-and-the-cou...
-
Synchronous vs Asynchronous The SSIS dataflow contain three types of transformations. They can be non-blocking, semi-blocking or full...
-
--SHRINKFILE and TRUNCATE Log File in SQL Server SELECT DB_NAME(database_id) AS DatabaseName, Physical_Name, Name AS Logical_Na...
-
Most of us know about JOINS in SQL Server and their types. But do we really know how they are interpreted in SQL Server internally. Today...
No comments:
Post a Comment