Header Ads

SQL Function

Here are the some of the SQL Functions:

@@CONNECTIONS - return the number of connections since sql server was started.
@@CPU_BUSY - return the time in milliseconds that the CPU has been actively doing work since sql server was started.
@@CURSOR_ROWS - the number of rows currently in the last cursor set opened on the current connection.
@@DATFIRST - returns the numeric value that corresponds to day of week.
1 -> Monday to 7 -> Sunday
@@DBTS - returns the last used timestamp for the current database.
@@ERROR - Return the error code of the last sql statement
@@IDENTITY - returns the identity value of the last sql insert statement.
@@FETCH_STATUS - return the indicator of the status of the last cursor fetch operation.

No comments:

Powered by Blogger.