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 12»»

Use of IDENTITY_INSERT? Expand / Collapse
Author
Message
Posted Tuesday, August 10, 2010 9:39 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 22, 2013 1:05 AM
Points: 248, Visits: 373
Comments posted to this topic are about the item Use of IDENTITY_INSERT?

KSB
-----------------------------
Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha
Post #967111
Posted Tuesday, August 10, 2010 9:39 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 16, 2014 9:38 AM
Points: 2,163, Visits: 2,189
Thanks for the question!
Post #967112
Posted Tuesday, August 10, 2010 11:56 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, June 30, 2014 2:51 AM
Points: 1,971, Visits: 369
nice and simple, thanks
Post #967152
Posted Wednesday, August 11, 2010 12:07 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:48 AM
Points: 13,261, Visits: 10,138
OK, this one was too easy



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #967160
Posted Wednesday, August 11, 2010 4:47 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 1:24 AM
Points: 697, Visits: 354
Both Question and answer don't have sufficient information about target.

What is the purpose of IDENTITY_INSERT ?
And answer
SET IDENTITY_INSERT allows explicit values to be inserted into the identity column of a table.


SET IDENTITY_INSERT is not meaningful and you can not identify result until ON or OFF is not include in this statement. SET IDENTITY_INSERT it self not allows explicit values to be inserted into the identity column of a table until you don't include ON in this.




Post #967296
Posted Wednesday, August 11, 2010 4:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:48 AM
Points: 13,261, Visits: 10,138
Developer 2005 (8/11/2010)
Both Question and answer don't have sufficient information about target.

What is the purpose of IDENTITY_INSERT ?
And answer
SET IDENTITY_INSERT allows explicit values to be inserted into the identity column of a table.


SET IDENTITY_INSERT is not meaningful and you can not identify result until ON or OFF is not include in this statement. SET IDENTITY_INSERT it self not allows explicit values to be inserted into the identity column of a table until you don't include ON in this.



http://msdn.microsoft.com/en-us/library/ms188059.aspx

Read the first two lines of this document...




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #967299
Posted Wednesday, August 11, 2010 6:00 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, May 19, 2011 7:26 AM
Points: 1,078, Visits: 289
da-zero (8/11/2010)
[quote]Developer 2005 (8/11/2010)
Both Question and answer don't have sufficient information about target.

What is the purpose of IDENTITY_INSERT ?
And answer
SET IDENTITY_INSERT allows explicit values to be inserted into the identity column of a table.


SET IDENTITY_INSERT is not meaningful and you can not identify result until ON or OFF is not include in this statement. SET IDENTITY_INSERT it self not allows explicit values to be inserted into the identity column of a table until you don't include ON in this.



You forgot to mention permissions or it won't work. Cmon people, it was a simple question that if you want to know more about it follow the link that was posted. I think some people are just mad they didn't get their points.
Seriously though, thank you for the question.
Post #967331
Posted Wednesday, August 11, 2010 7:09 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 14, 2014 9:47 AM
Points: 2,919, Visits: 2,525
Good question, thanks


Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
Post #967379
Posted Wednesday, August 11, 2010 9:18 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 1:24 AM
Points: 697, Visits: 354
hi da-zero

you are right and also that is mention in msdn.

but we can do both by this statement,either insert explicite or implicit.for more clearity ,it should be include.
Post #967516
Posted Wednesday, August 11, 2010 10:05 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 8:17 AM
Points: 21,213, Visits: 14,911
Thanks for the question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #967572
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse