KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
(Came up with this question in the course of trying to answer this other one ) Consider the following MS-SQL table, called GroupTable: GroupID ------- 1 2 3 where GroupID is the primary key and is an Identity column. How do you insert a new row into the table (and hence generate a new ID) without using IDENTITY_INSERT ON? Note that this: INSERT INTO GroupTable() Values () ... won't work. edit: we're talking SQL 2005 or SQL 2008 here.
Tags (comma-separated)
Save Edits
Cancel