Devlin, your check will print '@myvariable is NULL' when @myvariable has a value of zero.

declare @myvariable int

set @myvariable = 0

IF ISNULL(@myvariable, 0) = 0 PRINT '@myvariable is NULL'

Hi Neil. Whilst I appreciate that you can set ANSI_NULLS off (as previously commented), it is not recommended that you do so for the very reasons you state (i.e. SP's...

Interesting question. I got the right answer but the answer was quite educational.

However, I cannot get answer a) to work as the answer suggests....

Peter, On roads you have road signs dictating speed limits. Most of these dictate maximum speed limits but some dictate MINIMUM speed LIMITS. ...

In any exam or test, you must always read the question! There's no escaping that the word DEFAULT is part of the question. This...

64Kb is the correct answer - as confirmed by all of your queries. They all have a configured value of 65536 so this is the DEFAULT maximum

Thanks gbn. Something else for me to take to the SA's. Unfortunately we DO use named pipes as these were (are) what Microsoft recommended at the time. MS seem to...

Guys, Thanks very much for your input.

I KNOW this isn't really a good idea but it would save the potential disaster of having a second linked server under the new...

Your perception is indeed wrong.

As I said, change the * to the columns you require.

E.g.

INSERT INTO TS_Deleted

SELECT RecordNo, GetDate(), USER

FROM deleted

Your query seems...

Other replies seem over complicated.

How about:

INSERT INTO TS_Deleted

SELECT *, GetDate(), USER

FROM deleted

Change the * to the actual columns you require and this will work...

Shame! The 'correct' answer is clearly invalid. Why was this question not checked before release? You cannot have a registry key with a double slash in it.

I suppose that the...

Nothing wrong with the question. It's just a matter of experience.

BOL for SQL 7 states that you cannot use order by in views. Enterprise...

Would the load be reduced even if the query was changed to update a different 1000 rows each time?

Aren't all rows still processed within the same implicit transaction?

I agree that this is not only a VERY rude thing to say, it is also total b*****ks!

Have Sergiy and Colin NEVER got one of these questions wrong...