Thursday, 20 March 2014

sql system functions

SQL provided the system function which perform operation and return information about value, object or setting of SQL Server.

 Type of system function are below.

  @@Cursur Row :  Return how many rows are currently in last cursor set opened on the current connection.

  @@Datefirst : Return what is currently set as the first day of the week.

  @@Error : Return the error number of the last T-SQL  statement executed on current connection.

  @@FETCH_STATUS : used in conjustion with a FETCH statement.

  @@IDENTITY: Returns the last identity value inserted as a result of the last INSERT statement.

  @@ROWCOUNT : one of the most used system function return the number of row affected  by last statement.

No comments:

Post a Comment