IDENT_CURRENT | Varinder Sandhu

SQL Server 2008 – Get the next Identity Value

Varinder Sandhu SQL, SQL-Advanced, SQL-General, SQL-Scripts, SQL-Tips and Tricks, Varinder Sandhu

Question: How to get the next Identity Value in SQL Server 2008? Answer: It is very simple to the get the identity value in SQL Server. Let’s see with the example below Lets‘s create some dummy data as mentioned below … In SQ Server, there are two functions IDENT_CURRENT and

» Read more

IDENT_CURRENT, IDENT_INCR, Identity Value

SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY not working with Linked Server or Remote server ???

Varinder Sandhu SQL, SQL-Linked Server, Varinder Sandhu

Hello Friends, I have faced a problem using SCOPE_IDENTITY, IDENT_CURRENT, and @@IDENTITY with Linked server Let me explain with example as below Question: We have set of applications which are running on SQL 2000, due to some reason we need to migrate sub set of applications to SQL 2008. Now

» Read more

@@IDENTITY, IDENT_CURRENT, SCOPE_IDENTITY, SQL, SQL Server