IDENTITY Column in SQL Server
from Alternatives to @@IDENTITY in SQL Server 2000
SELECT @@IDENTITY
SELECT IDENT_CURRENT('tablename')SELECT SCOPE_IDENTITY()
Understanding Identity ColumnsSET 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