Comparing identity values returned by IDENT_CURRENT, @@IDENTITY and SCOPE_IDENTITY
The following example shows the different identity values that are returned by IDENT_CURRENT, @@IDENTITY, and SCOPE_IDENTITY.
Beginner School is optimized for learning. This is useful for getting basic knowledge with easiest way. Tutorials, examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. With the help of other reference book and website, the motive to provide you easiest way to understand the coding, technology and other things.....
Related Post
IDENTITY (Function)IDENTITY (Function)Is used only in a SELECT statement with an INTO table clause to insert an identi
SQL Basic: SQL Data TypesSQL Data Type:is an attribute that specifies type of data of any object. In each column, varia
SQL Basic- Important thing Keep Mind it....Important thing Keep Mind it.... Important ThingSome database systems require a semicolon at t
SQL Basic- SQL INSERT INTO CommandSQL INSERT INTOThis statement is used to insert new records in a table.SQL INSERT INTO Statement&nb
Conversion Conversion Emoticon Emoticon