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

TSQL - Identity_Insert Expand / Collapse
Author
Message
Posted Thursday, August 22, 2013 6:54 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 2:35 AM
Points: 2,500, Visits: 2,381
In the past 10 years, I played a lot with SET identity_insert. I'm a specialist!
Post #1487220
Posted Thursday, August 22, 2013 7:27 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 18, 2014 3:26 AM
Points: 262, Visits: 232
nice question....

Manik
You cannot get to the top by sitting on your bottom.
Post #1487246
Posted Wednesday, August 28, 2013 2:02 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 5:20 AM
Points: 3,546, Visits: 2,651
I've been playing with identity columns quite lot in the past two years so found it easy to resolve. But nice question. Cheers
Post #1489056
Posted Friday, September 13, 2013 8:08 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 10:53 PM
Points: 160, Visits: 235


If I hadn't tried it out I would have gotten it wrong.

again...

...is this English grammar correct, by the way?


________________________________________________________
If you set out to do something, something else must be done first.
Post #1494591
Posted Friday, September 27, 2013 10:09 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 8:12 AM
Points: 254, Visits: 317
umm, what should you do when you can't perform simple math in your head? This was a pretty simple question (since I have been dealing with IDENTITY_INSERT for several years now) but the simple addition of 100 + 1 + 1 trips me up? Time to back to the dunce cap...
Post #1499497
Posted Friday, September 27, 2013 12:53 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:18 PM
Points: 8,706, Visits: 9,253
Dscheypie (9/13/2013)


If I hadn't tried it out I would have gotten it wrong.

again...

...is this English grammar correct, by the way?

Yes.
But England is full of ignorant pedants who will claim it is not grammatical, because they insist that the past participle of get is not gotten but got. Just about everyone in the USA says gotten (as did just about everyone in England until not very long ago, which is why the pp of forget is forgotten, of beget is begotten and so on, and why the phrase like "ill-gotten gains" is used by just about everyone). I'm Scottish, so I both forms of the past participle - which I use at any time depends on which feels right at the time.


Tom
Post #1499554
Posted Friday, September 27, 2013 3:00 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 10:53 PM
Points: 160, Visits: 235
logitestus (9/27/2013)
umm, what should you do when you can't perform simple math in your head? This was a pretty simple question (since I have been dealing with IDENTITY_INSERT for several years now) but the simple addition of 100 + 1 + 1 trips me up? Time to back to the dunce cap...


Of course, logitestus, if I had added 100 + 1 + 1 and similar complex tasks for years like you did I would have solved this problem hopefully as souvereign as apparently you did.

So I respectfully admire your capabilities and competence and humbly ask for forgiveness for not having a comparable expertise in this area. In other areas of course I sometimes proove to be a bit more exercised like social behaviour. Therefore I gratefully thank you and decline your offer, the dunce cap, with greatest respect: Please keep it for yourself because you are obviously so well versed in the use of it...



________________________________________________________
If you set out to do something, something else must be done first.
Post #1499596
Posted Friday, September 27, 2013 3:24 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 10:53 PM
Points: 160, Visits: 235
L' Eomot Inversé (9/27/2013)

Yes.
But England is full of ignorant pedants who will claim it is not grammatical, because they insist that the past participle of get is not gotten but got. Just about everyone in the USA says gotten (as did just about everyone in England until not very long ago, which is why the pp of forget is forgotten, of beget is begotten and so on, and why the phrase like "ill-gotten gains" is used by just about everyone). I'm Scottish, so I both forms of the past participle - which I use at any time depends on which feels right at the time.


Hi, Tom,

thank you for your off topic explanation, off topic at least in the sense of SQL Server!

I wasn't sure of the use of past participle, yet I tend to exercise my poetic capabilities even in a technical forum, even for the price of ludicrousness

Anyway: Aren't you interested in some Vogon poetry?


________________________________________________________
If you set out to do something, something else must be done first.
Post #1499601
Posted Friday, September 27, 2013 6:37 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 2:18 PM
Points: 8,706, Visits: 9,253
Dscheypie (9/27/2013)
Hi, Tom,

thank you for your off topic explanation, off topic at least in the sense of SQL Server!

I wasn't sure of the use of past participle, yet I tend to exercise my poetic capabilities even in a technical forum, even for the price of ludicrousness

Anyway: Aren't you interested in some Vogon poetry?

O mo chreach, chan 'eil! Chan 'eil idir! 'S ann bhiodh bàrdachd Bhogonach gun bhun gun bharr gun dreach, cho neo-bhlasta ri sgaot, agus chuireadh e dìreach subh ghràin orm! Is mise bhiodh briste brùite ma chuireadh tu rium càil dhith! At least not unless you can provide it in a translation into my language, which would surprise me horribly, and almost certainly not even then .


Tom
Post #1499626
Posted Saturday, September 28, 2013 10:12 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 10:53 PM
Points: 160, Visits: 235
Hi, Tom,

can you imagine my joy when I first thought to have found another worshipper of Vogon poetry? And my disappointment when I realized that this was no Vogon, but a mere mundane language up to now unknown to me? Gaelic... :-(
...but of course wonderful, too!

Well, give me some time; I hope to present you a very special Vogon piece of artistry. I just suffer from some difficulties: Import restrictions (potential life threatening devices are not willingly welcomed), duty, tolls and taxes, you know...


________________________________________________________
If you set out to do something, something else must be done first.
Post #1499695
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse