Although I don't know hi, I think I would like him, too.

Another solution to escape this mess with quotation marks

SELECT QUOTENAME('FarmerJack','''')

One caveat with QUOTENAME is that the input string is...

Oh, and by the way, Ken,

I really like the words in your autosignature.

Change

Select @DatabaseName = 'FarmerJack'

to

Select @DatabaseName = '''FarmerJack'''

Brian Knight,

I reject the prize from last month contest!

May you please inform Anthony from logpi of my decision!

Feel free to give the prize to someone else. I would suggest...

But what happens, when the original poster rated his *best* answer, and some time later someone comes up with a *better* solution?

How should this be handled?

Deduct the points from the...

No problem, Robert as this post will give me the 2 point I've missed (or was it 3 points)

Who knows?

One thing that comes to mind is that the clustered index pages must be loaded into memory when using a nonclustered...

Please avoid double posts.

Although this seems to be the more apprpriate category, we should leave the

thread here

Sorry, but what exactly is now your question?

Look at the explanation of RETURN in BOL.

The RETURN statement unconditionally terminates a query, stored procedure, or batch. None of the statements in a stored procedure or batch following the...

BOL covers a topic on optional parameters. Also see my reply on your other thread. That is the example from BOL

Take a look at sp_password in BOL or sa -> password in BOL.

You missed this one xp_regenumkeys

Or am I blind?

Am I reading it right that you want to return an error code in case such occurs, otherwise the last inserted row?

Andrew, why are you asking on how to load pictures, when you actually want to play media files?

Although I don't know for sure that it is correct, I would look...