SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Aram Golbaghi / Identity Insert / Latest Posts

RE: Identity Insert

npcrwill8 — Mon, 09 Mar 2009 13:16:53 GMT

gezz,, I am missing the point of this. I thought the User needs to insert data ?

RE: Identity Insert

Tom Garth — Wed, 04 Mar 2009 12:27:28 GMT

I can't picture ever using this knowledge, but learning it is still cool.

RE: Identity Insert

James Rochez — Mon, 02 Mar 2009 10:31:18 GMT

Note that[code]insert into TableName default values[/code]should not be confused with[code]insert into TableName (columnName) values(default)[/code]The latter of which is not valid for an identity column.

RE: Identity Insert

brdudley — Mon, 02 Mar 2009 08:29:13 GMT

I came across the Insert Default Values when I taught a SQL class, many years back. It was an odd way to start a chapter on data modification statements. It is mostly useful for trivia contests, to be honest.The best explanation I can come up with, for where it might be used, is in a situation -- like a call center -- where you want to latch an identity, but don't have enough data to fill in the blanks. There might be some uses around logging, but usually there is more to be recorded.

RE: Identity Insert

Shaun McGuile — Mon, 02 Mar 2009 04:21:09 GMT

See my thread.....[url=http://www.sqlservercentral.com/Forums/Topic622104-338-1.aspx]http://www.sqlservercentral.com/Forums/Topic622104-338-1.aspx[/url]:D--Shaun

Identity Insert

aram_golbaghi — Sun, 01 Mar 2009 13:10:07 GMT

Comments posted to this topic are about the item [B]Identity Insert[/B]