Type Declaration Instruction This instruction is used to declare the type of variables being used in the program. Any variable used in the p...
Read More
Instructions to write a C program
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...
Read More
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
How to compare identity values returned by IDENT_CURRENT, @@IDENTITY and SCOPE_IDENTITY?
Comparing identity values returned by IDENT_CURRENT, @@IDENTITY and SCOPE_IDENTITY The following example shows the different identity values...
Read More
How to return the last identity value generated for a specified table?
Returning the last identity value generated for a specified table: Following example returns the last identity value generated for the Perso...
Read More
DATALENGTH Function
DATALENGTH (Transact-SQL) This function returns the number of bytes used to represent any expression. Syntax DATALENGTH ( expression ) Arg...
Read More
Data Type Functions
Data Type Functions (Transact-SQL) Data type functions return information about various data type values. In This Section we read the follow...
Read More
Instructions to write C Program
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 ...
Read More
Subscribe to:
Posts
(
Atom
)