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)
-
UNION: To select related information from two tables UNION command is used. It is similar to JOIN command. • UNION All: The UNION ALL comm...
-
Created a table called SegmentDetails. It has 2 columns Segment and Details. Segment contains the category name while Details contains the ... -
ere are Inserted and Deleted logical tables in SQL Server. These tables are automatically created and managed by SQL Server internally to h...
No comments:
Post a Comment