OK, go stand in the corner.  Then smack yourself a few times across the face.  Then go back to programming 101 and learn how to make use of BEGIN and...

SOP kluge

1. create a select statement that returns the rows (as 1 string column) you're looking for (e.g. join to syscolumns, etc. to get relevant data-- 1 row per column per...

"As a senior DBA, I don't mind if a company tells me that they can't hire me because I'm not certified. To me that is a powerful indication that they...

Actually the girl at the desk is holding this guy's chest open, she says the color is more of a 'coral'... Surely someone must have an answer that makes use...

Do the outer join and filter where table2.key IS NULL

Just had a PM about this--here it is, quick and dirty scramble utility.  Free to all-- you'll never see me copyright anything.  Feel free to fix/make better (and send me...

Use CASE, refer to the books on line

build a temp table with an identity col and populate from some known record count

SELECT IDENTITY( INT, 10000, 1 ) AS id, ' ' AS JUNK

INTO #t

FROM SYSOBJECTS

INSERT INTO #t...

Actually the term zulu refers to greenwich (mean time) and not the format

The answer is yes and no.  Or is it no and yes?

You might be better off stating your issue/objective than asking this question.  What are you trying to accomplish?

The issue of char vs. int is simple:

1. storage size

2. the low level comparison that goes on

#1 is straight forward: int is 4 bytes and char = whatever.  The effect...

Just after I post, the perfect analogy comes to mind:

If your problem is that you choose to keep a wolf in your sheep pen it is a silly solution to...

But now you're talking about a different beast.  The security flaw which is microsoft. Meaning Outlook, IE, etc.

The security hole which is Outlook et. al. is not addressed by not...

Well if you're that lazy, and you know that all of the data is in the new( excell ) table (no columns missing), you could join the two table to...

I saw a great documentary on traffic safety a while back and what I loved about it was that they hammered home a point I've been telling people about for...