<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Suresh Babu Kari
»
Use of IDENTITY_INSERT?
13 posts, Page 1 of 2
1
2
»»
Use of IDENTITY_INSERT?
Rate Topic
Display Mode
Topic Options
Author
Message
Kari Suresh
Kari Suresh
Posted Tuesday, August 10, 2010 9:39 PM
SSC Veteran
Group: General Forum Members
Last Login: Tuesday, January 01, 2013 11:12 PM
Points: 248,
Visits: 372
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
UMG Developer
UMG Developer
Posted Tuesday, August 10, 2010 9:39 PM
SSCrazy
Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163,
Visits: 2,148
Thanks for the question!
Post #967112
ziangij
ziangij
Posted Tuesday, August 10, 2010 11:56 PM
SSCommitted
Group: General Forum Members
Last Login: Friday, May 17, 2013 2:53 AM
Points: 1,529,
Visits: 359
nice and simple, thanks
Post #967152
Koen Verbeeck
Koen Verbeeck
Posted Wednesday, August 11, 2010 12:07 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 6:39 AM
Points: 9,376,
Visits: 6,472
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
SQL Writer
SQL Writer
Posted Wednesday, August 11, 2010 4:47 AM
Say Hey Kid
Group: General Forum Members
Last Login: Tuesday, August 28, 2012 4:29 AM
Points: 688,
Visits: 311
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
Koen Verbeeck
Koen Verbeeck
Posted Wednesday, August 11, 2010 4:52 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 6:39 AM
Points: 9,376,
Visits: 6,472
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
Dennissinned
Dennissinned
Posted Wednesday, August 11, 2010 6:00 AM
Ten 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
sjimmo
sjimmo
Posted Wednesday, August 11, 2010 7:09 AM
SSCrazy
Group: General Forum Members
Last Login: Yesterday @ 7:15 AM
Points: 2,865,
Visits: 2,467
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
SQL Writer
SQL Writer
Posted Wednesday, August 11, 2010 9:18 AM
Say Hey Kid
Group: General Forum Members
Last Login: Tuesday, August 28, 2012 4:29 AM
Points: 688,
Visits: 311
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
SQLRNNR
SQLRNNR
Posted Wednesday, August 11, 2010 10:05 AM
SSCoach
Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733,
Visits: 12,332
Thanks for the question.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
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 »
13 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
