Well, okay,...

Still Jonathan's reasoning is valid!

Don't know if I understand you correctly, but if you are asking how to get a default value of a *space*, I would look at the table design, jump to...

Thanks for the help. I am going to use EXEC(). This allowed me to get the majority of the selections and is acceptable. Thanks for the link.

Oops,...

Quoted from Inside SQL Server 2000

Multiple-Table Joins

According to some folklore, SQL Server "does not optimize" joins of more than four tables. There was some truth to this in earlier versions...

For the sake of completeness and if you are not afraid of using some undocumented extended procedures what about this one?

DECLARE @delta INT

EXEC master.dbo.xp_regread

'HKEY_LOCAL_MACHINE'

, 'SYSTEM\CurrentControlSet\Control\TimeZoneInformation'

, 'ActiveTimeBias'

, @delta OUT

SELECT

GETDATE()...

?

See the answers here

Vyas has some ideas on this published here

Now, that's a true word!

Posts in the fora surely should help the questioners. But mostly they are quickly typed (good and bad). Now writing articles (at least good ones) is...

Basically there is no difference, except that you can define a database wide default with CREATE DEFAULT. This default you can bind via the mentioned s_proc to as many column...

sp_executeSQL requires the SQL statement as unicode string. So you best bet is a nvarchar(4000). If your string is longer than this you cannot use sp_executeSQL, but must use EXEC()...

A lot of irritations could have been avoided, if you had posted a 'What do you think on a monthly contest?' thread prior to establishing it actually.

Not to make...

Ready for an AHA effect?

declare @Month2 as char

declare @Day2 as char

declare @Year2 as char

is the same as

declare @Month2 as char(1)

declare @Day2...

Hey, your DBA is a wise man.

Actually you can use far more than 15 parameters in an s_proc and for the grouping...

Take a look at BOL for CAST and CONVERT.

When converting character or binary expressions (char, nchar, nvarchar, varchar, binary, or varbinary) to an expression of a different data type,...

What's wrong with sp_executesql?