Beginner School: SQL Server

SQL Server

Showing posts with label SQL Server. Show all posts

Find list of all the jobs currently running on server

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...

SQL_VARIANT_PROPERTY (Transact-SQL) This functions returns the base data type and other information about a sql_variant value. Syntax SQ...

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...

IDENT_SEED This function returns the original seed value (returned as numeric(@@MAXPRECISION,0)) that was specified when an identity colum...

IDENT_INCR Funtion This function returns the increment value (returned as numeric (@@MAXPRECISION,0)) specified during the creation of an i...

IDENT_CURRENT This function returns the last identity value generated for a specified table or view. The last identity value generated can ...

Comparing identity values returned by IDENT_CURRENT, @@IDENTITY and SCOPE_IDENTITY The following example shows the different identity values...

Returning the last identity value generated for a specified table: Following example returns the last identity value generated for the Perso...

DATALENGTH (Transact-SQL) This function returns the number of bytes used to represent any expression. Syntax DATALENGTH ( expression ) Arg...