TechyGypo
Techy stuff I find out about in the world of computers and stuff like that...
Wednesday, 19 December 2012
Insert Into a Table With Only One Identity Column
If you have a table that as only one column and that column is an identity column, then in order to
INSERT
into it, you need to use this statement:
INSERT INTO [MyTable] DEFAULT VALUES
This works in SQL Server 2008 and I haven't tested in earlier versions.
In SQL Server 2012, we have the introduction of a
SEQUENCE
. You could consider using one of those as an alternative.
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment