I didn't read all 5 pages of comments, so maybe someone else has already pointed this out.... I know the rules of the sp_ prefix, BUT in the code block...

I don't see the point.... if that's the 'standard' then the DB should have been developed that way to begin with. If the DB has had any code written against...

MICHAEL DEPAULA (9/9/2007)

~~~~~~~~~

This is what your query would look like using the column names you provided as an example:

CREATE TABLE dbo.TEMP_myTable (id, Name, address, phone) ON [PRIMARY]

GO

IF EXISTS (SELECT *...

this isn't really an IT phrase, but a couple of us hung on to it. Several years ago I was trying to explain something to a coworker who just...

Kansas City and Texarkana immediately come to mind as spanning States.

All - thanks for all the replies. It wasn't really fair of me to post an hour or so before a long weekend, but all replies were appreciated.

opc.three -...

Thanks for all the quick responses!

Dixie/diamondgm - yes, I was pretty sure the article I read defined it as "Right outer join" and that it was depricated.

opc.three - yeah,...

Well, dog poo... that's what I had been trying but couldn't get the parser to like it. Maybe I still had my parathesis messed up 'cause it seems to...

if it's in vb6.... do you own the code? If so, you could put some logging into it to tell you which pieces run OK. You're probably going...

no, I didn't. I DO remeber reading somewhere that sql 2000 should be on sp4 before the upgrade... but I guess I had a senior moment. The old DB...

Hi -

I have just successfully upgraded a sql 2000 sp2 database to sql 2008 r2 using the backup and restore method. I upgraded the database from...

the @name = @value line is just to indicate that parameters have to be passed...

one more vote for "the answer is for a different question"

well, this is untested but nobody else has taken a stab at it.... you could try the "Regional and Language settings" applet in control panel. It allows you to set...

the image does indeed make it easy to read, but... there are many VERY good SQL volunteers on this site that always seem eager to help but you have to...