Check COLUMNPROPERTY in Books Online. You can use this function to determine is a column is an identity column.

gserdijn (4/28/2009)

---

This was what I intended for the problem on page 8 which happens to look much the same as Samuel Vella's solution.

SET ROWCOUNT 5000;

SELECT IDENTITY(INT,0,1) AS id INTO #Tally...

William Plourde (4/28/2009)

---

Thanks for the replies. I was able to get both examples to work and since I have not been using CTE it was a good excuse to read...

Well, if you must know... this is his latest thread

😉

GSquared (4/28/2009)

---

Lynn Pettis (4/28/2009)

---

Bob Hovious (4/28/2009)

---

Somewhere that man is getting...

Bob Hovious (4/28/2009)

---

Somewhere that man is getting well paid for...

You know, I guess it is really hard to teach someone fish when you are in the middle of the desert...

Not until you have worked it first. Just pay attention to your parens as you work through the where clause.

I'll have to agree with Gus on this, but it would help to see the current code to really make a determination.

Hugo Shebbeare (4/28/2009)

---

Hello, with respect to MOSS, I think you already know the best way to optimise it already - just split off your indexes onto another physical disk/spindle etc....

Could be open to interpretation, but this sure sounds like an inner join to me:

I have a question on how to join 2 tables that have a one-to-many relationship such...

GilaMonster (4/28/2009)

---

I might join you this time. For some reason some of the posts over the last few days have been getting to...

spatley (4/28/2009)

---

I like this example for the additional reason that it is explicit. Using techniques like between '2009-01-01' and 2009-01-02' to get dates that take place on the first hides...

tpepin (4/28/2009)

---

Andy DBA (4/28/2009)

---

I think suggestions for proper formatting and good comments are left out of many discussions and examples because the focus is more on performance (rightly so) and...

The desert is looking good again...

The White House window washer is back...