IDENTITY Column in SQL Server
from Alternatives to @@IDENTITY in SQL Server 2000
SELECT @@IDENTITY
SELECT IDENT_CURRENT('tablename')
SELECT SCOPE_IDENTITY()
Understanding Identity Columns
SET IDENTITY_INSERT Yaks ONhow to get an Identity value with SQL Server 2005
How-To: using SQL Server 2005's OUTPUT to return generated identity
use OUTPUT
0 Comments:
Post a Comment