Concat_null_yields_null

Feb 24, 2004

How do you set the option CONCAT_NULL_YIELDS_NULL to OFF
in all databases and permenantly

???

View 6 Replies


ADVERTISEMENT

How To SET CONCAT_NULL_YIELDS_NULL OFF?

Nov 5, 2007

 I'm writing a select query that's, in effect, like this: Select FirstName + ' ' + LastName FROM Users. How do I get just the first name to display in my gridview if last name is null?  I'm familiar with aspx and aspx.cs files, but stored procedures are beyond me right now.   

View 1 Replies View Related

How To Check Setting Of CONCAT_NULL_YIELDS_NULL

Feb 12, 2008

I would like to check the setting of this variable in our MS-SQL 2000database. Also, is there info on what the default value of thisvariable is?

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved