Get a list of SQL Server Agent Jobs --On each server, you can query the sysjobs table in the msdb. For instance: SELECT job_id, [name] FROM...
Read More
Showing posts with label SQL Server. Show all posts
Showing posts with label SQL Server. Show all posts
SQL_VARIANT_PROPERTY Function
SQL_VARIANT_PROPERTY (Transact-SQL) This functions returns the base data type and other information about a sql_variant value. Syntax SQ...
Read More
IDENTITY (Function)
IDENTITY (Function) Is used only in a SELECT statement with an INTO table clause to insert an identity column into a new table. Although sim...
Read More
IDENT_SEED Function
IDENT_SEED This function returns the original seed value (returned as numeric(@@MAXPRECISION,0)) that was specified when an identity colum...
Read More
IDENT_INCR Funtion
IDENT_INCR Funtion This function returns the increment value (returned as numeric (@@MAXPRECISION,0)) specified during the creation of an i...
Read More
IDENT_CURRENT function
IDENT_CURRENT This function returns the last identity value generated for a specified table or view. The last identity value generated can ...
Read More
Subscribe to:
Posts
(
Atom
)