COALESCE

Question

Viewing 3 posts - 31 through 32 (of 32 total)

You must be logged in to reply to this topic. Login to reply

@Cassie SSC Eights! Points: 890 More actions · Answer 1

SSC Eights!

Points: 890

October 18, 2012 at 3:32 am

Too easy...

Paul White SSC Guru Points: 150467 More actions · Answer 2

Hugo Kornelis (10/17/2012)
I think the choice will be integer, but I'm not sure.

Yes it is integer.

USE tempdb;

SELECT NULL AS n INTO #z

EXEC sys.sp_columns

@table_name = N'#z',

@column_name = N'n';

kapil_kk SSC-Insane Points: 21316 More actions · Answer 3

easy one

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/