If it's temporary... (from Books Online)

SET IDENTITY_INSERT [ database_name . [ schema_name ] . ] table { ON | OFF }

If it's permanent removal you want, you'll need to define...

My apologies... see the following URL for how to make a Tally table...

http://www.sqlservercentral.com/scripts/Advanced+SQL/62486/

This is the second time this same question has been asked... and just like I said on that identical post, directly updating system tables is a form of "Death by...

We're getting there... in the example you just gave, should 1 2 3 be in a single column or 3 columns? If 3 columns, what shall be their names?

{insert sounds of cheers and applause here}

Congrats one and all! Job well done!

To further Jacob's suggestion... here's the test code...

--===== Do a couple of presets for appearance

SET NOCOUNT ON

SET ANSI_WARNINGS OFF

--===== Simulate a 2...

Only way to tell is to see the code 😉

You will never get an INDEX SEEK using SELECT *... only index scans.

Not enough coffee, Sergiy... which method are you recommending to use?

How many items can you have? Also, should they all be in separate columns or ???

Heh... I handed Babbage gears 😉

Bob Boursaw (4/6/2008)

---

Jeff,

With all due respect, I have read Ken's post about 200 times over this weekend and unfortunately, due to my lack of experience and knowledge with SQL,...

If I need to insert constants, I use INSERT/SELECT... if I need to insert more than one row of constants, I use INSERT/SELECT/UNION ALL... I can't actually remember the last...

Composite PK's are wonderful... but not for this problem. It would be so much easier if you had an IDENTITY column named RowNum because, like I said, this is...

True... it also...