Where do you get those?  Wouldn't mind seeing the rest of them...

Gotta love that... a GUI based tool that doesn't support the base product... kinda like EnterPrise Manager with Case statements...

Heh... or...

Infinity = undefined

Null = undefined

1/Infinity = undefined?

1/Infinity = Null?

Just havin' fun

Didn't think of them that way... operative words were "didn't think"   Thanks, Serqiy.

And, if you do have a clustered index in the right spot...

GO

--===== Create and populate a 1,000,000 row test table.

     -- Column RowNum has a range of 1...

Pretty sure (been a while since I've had to check, DBA's at work normally do this) PCI compliance doesn't allow trusted connections.  If you're not worried about PCI, then that'll...

From the FROM clause down, updates with joins look pretty much like what you'd find in a SELECT...

 UPDATE t1

    SET somecol =t2.somecol

   FROM @Table1 t1,

        @Table2 t2

  WHERE t1.someothercol...

There's some sort of nasy ol' timeout... I always do a select-all and copy before I try to post... just in case...

Heh... good thread, huh?

You bet... thanks for the feedback!

Better have a good list of logins and passwords, then   And figure out a really good way to change them in the code...

If you really want to impress them, create an "External Data Range" that queries the database using a well written view and set it up to automatically update every ten...

Heh... geek...

Heh... then there's that