Articles List - DotNetMirror

Stats

Resources

Publish New Article

Insert data to table with only one IDENTITY column exists in table
	If we have a table with only one column which is marked as IDENTITY column, then how we will insert data to table? This scenario will be very rare. But we will see how to insert data to table with only one IDENTITY column exists.
By: Ashok Nalam \| 24 May 2013 \| SQL Server \| Views: 8501 \| Comments: 0 \| Tags:identity insert table

SET IDENTITY_INSERT for Table Variable

By: Ashok Nalam \| 09 Jan 2014 \| SQL Server \| Views: 15735 \| Comments: 2 \| Tags:identity table variable