You'd use the SCOPE_IDENTITY like this:

INSERT INTO table

(Desc,UpdateDate,Whatever)

VALUES

('My Description','1/14/2007','Something)

SELECT SCOPE_IDENTITY()

That would insert a row into the table and then give you the identity value generated by that table from the...

Yeah, our company is weird about working from home too. I'm doing it today because a ton of snow was dumped on us. As much as I like my job,...

Assuming I understood the question, if you're asking how to determine what the last identity value inserted was is to use the SCOPE_IDENTITY() function. This returns the last Identity value...

We're only supposed to work 40 hours a week too, but we're also on call. I worked a good two-three hours this weekend because of some problems in production. It's...

While I still think manipulating XML in 2000 is a waste of time, that's a very good idea. If you absolutely HAVE to do it, taking advantage of what you...

2000 doesn't support XQuery. You will have to use string functions. I don't have any samples because, frankly, it wasn't worth doing in TSQL in 2000. Instead we used VB,...

The most immediate benefit you'd see from using the CTE vs. a function is that the CTE will take advantage of indexes within the system as part of it's operation....

Microsoft has a tool to generate load from trace files located here. You can also go for more sophisticated third party offerings like SQLScaler from Idera or Benchmark Factory from...

How about taking the initial query and placing it into a sub-select and the wrapping the outer where clause around that. Then you can refer to the columns derived from...

I second the vote for XML PATH. It will make a huge difference.

The one piece of advice I can give you is to get the Microsoft Upgrade Advisor. This will identify the places where you need work in your existing 2000 database.

Excellent. Thanks Steve.

Fourth, assuming that's not homework, if it's proprietary information, you sure shouldn't be posting it willy-nilly on the internet.

Rereading your description, it sounds like you might be doing RBAR (row-by-agonizing-row) processing. Are you sure the process that you mention that is row-by-row can't be done as a batch?...

Thanks. His blog seems to be offline right now. I'll check on it later.

I understood that there were few if any fundamental changes, but I just wanted the chance to...