Saturday 13 July 2013

What is @@Rowcount, @@Error and @@Identity


@@Rowcount is used to display the number of rows affected by last SQL statement.

@@Error displays the error number for the last SQL statement executed. The value is zero,if there is no error.

@@identity returns the last inserted identity value.
-
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

C# LINQ Joins With SQL

There are  Different Types of SQL Joins  which are used to query data from more than one database tables. In this article, you will learn a...