Others

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