Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Aram Golbaghi » Identity Insert
Add to briefcase

Identity Insert Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
aram_golbaghi
Posted Sunday, March 01, 2009 1:10 PM
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: Friday, October 26, 2012 11:59 PM
Points: 579, Visits: 87
Comments posted to this topic are about the item Identity Insert
Post #666288
Shaun McGuile
Posted Monday, March 02, 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 04, 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
brdudley
Posted Monday, March 02, 2009 8:29 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:16 AM
Points: 1,234, Visits: 1,394
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
James Rochez
Posted Monday, March 02, 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
Tom Garth
Posted Wednesday, March 04, 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 04, 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
npcrwill8
Posted Monday, March 09, 2009 1:16 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 5:19 PM
Points: 53, Visits: 227
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

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.