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)
-
We can filter an axis based on the members, or based on the measure value. Based on the members: begins with F or after Based on th...
-
Synchronous vs Asynchronous The SSIS dataflow contain three types of transformations. They can be non-blocking, semi-blocking or full...
-
---Fibonacci numbers declare @fib table(fib_id bigint,fib_val bigint) declare @current_val bigint,@previous_val bigint,@new_val bigint in...
No comments:
Post a Comment