Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Identity Insert Expand / Collapse
Author
Message
Posted Sunday, March 1, 2009 1:10 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Wednesday, April 30, 2014 10:27 AM
Points: 936, Visits: 160
Comments posted to this topic are about the item Identity Insert

Aram Koukia: http://www.koukia.ca
Post #666288
Posted Monday, March 2, 2009 4:21 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, October 4, 2012 9:20 AM
Points: 583, Visits: 1,060
See my thread.....

http://www.sqlservercentral.com/Forums/Topic622104-338-1.aspx

:D

--Shaun


Hiding under a desk from SSIS Implemenation Work
Post #666461
Posted Monday, March 2, 2009 8:29 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:36 PM
Points: 1,371, Visits: 1,542
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.
Post #666635
Posted Monday, March 2, 2009 10:31 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 9:07 PM
Points: 1,529, Visits: 824
Note that
insert into TableName default values

should not be confused with
insert into TableName (columnName) values(default)

The latter of which is not valid for an identity column.



Post #666732
Posted Wednesday, March 4, 2009 12:27 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, February 4, 2011 7:20 AM
Points: 977, Visits: 1,499
I can't picture ever using this knowledge, but learning it is still cool.

Tom Garth
Vertical Solutions

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
Post #668591
Posted Monday, March 9, 2009 1:16 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, March 21, 2014 3:24 PM
Points: 53, Visits: 233
gezz,, I am missing the point of this. I thought the User needs to insert data ?


Post #671908
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse