February 2016 ~ Beginner School

Type Declaration Instruction in C

Type Declaration Instruction This instruction is used to declare the type of variables being used in the program. Any variable used in the p...

C Instructions Now that we have written a few programs let us look at the instructions that we used in these programs. There are basically t...

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

Data Type Functions (Transact-SQL) Data type functions return information about various data type values. In This Section we read the follow...

C Instructions Now that we have written a few programs let us look at the instructions that we used in these programs. There are basically ...