Glad I could help.

select CONVERT(varchar(10),getdate(),121)

Glad I could help. 🙂

Yep, I believe that I am following it OK.

What you want to use is the SCOPE_IDENTITY() function, which returns the last identity value (for any table) that you created in...

Its a scripting Option. Look in SSMS under Tools..Options.., select the "Scripting" tab, then scroll down to the "Include IF NOT EXISTS clause" option and set it to FALSE.

And for what it's worth: I have used the method that you have in your original post many times and it is faster than any other method that I have...

josemyj (12/30/2008)

---

These values are chosen arbitrary by the decision support department depending of the way the butterflies move through the window when it rains...

So they are randomly chosen from a...

You should not be using the IDENTITY INSERT option, except for restoring from your archive. You should let SQL assign the identity values for all new records.

Right. What Kendall said. 🙂

Cute trick, Madhivanan. Of course "[GO]" and "EXEC GO" would also work, but I like this.

One thing that I noticed is that you have reversed the roles of the tables in Jeff's example. Originally, Jeff had #MyInTable as the subordinate table, but you are...

This happens when you have the "If EXISTS" option on.

Yep. allows me to talk to R2 units and other Modems. 😛

19.2, you know Jeff....

anbillava (12/29/2008)

---

There are different instance of generating id.. Most of which i can replace by identity. But in one case a random number will created by one of method and...