SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by VM / NULL & 'NULL' / Latest Posts

RE: NULL & 'NULL'

Paul White — Thu, 01 Apr 2010 07:42:35 GMT

[quote][b]The Dixie Flatline (4/1/2010)[/b][hr]The problem is about to go away. See Steve's Editorial for April 1, 2010.[/quote]:-)

RE: NULL & 'NULL'

The Dixie Flatline — Thu, 01 Apr 2010 07:28:10 GMT

The problem is about to go away. See Steve's Editorial for April 1, 2010.

RE: NULL & 'NULL'

Paul White — Tue, 30 Mar 2010 09:11:44 GMT

There is nothing good about NULL. Discuss. :-D

RE: NULL & 'NULL'

The Dixie Flatline — Thu, 04 Feb 2010 15:01:49 GMT

For more fun.....declare @t1 table (id1 int identity(1,1) primary key, [null] varchar(20))insert into @t1 values('Null')insert into @t1 values(null)insert into @t1 values(default)declare @t2 table (id2 int identity(11,1) primary key, [null] varchar(20))insert into @t2 values('Null')insert into @t2 values(null)insert into @t2 values(default)select * from @t1select * from @t2select * from @t1 t1cross join @t2 t2where t1.[null] <> t2.[null]select * from @t1 t1cross join @t2 t2where t1.[null] = t2.[null]

RE: NULL & 'NULL'

Julie Breutzmann — Thu, 04 Feb 2010 10:54:09 GMT

[quote][b]ronmoses (2/4/2010)[/b]Really! My favorite part of QotD is the ensuing argument! Ron Moses[/quote]Me, too. I often learn more from the ensuing discussions.Julie

RE: NULL & 'NULL'

JF1081 — Thu, 04 Feb 2010 09:33:02 GMT

So I was like, of course they are null. you do not ahve to set it to null it is already null so of course the answer is A.Then I slapped my forehead when I realized I missed the single quotes in the select @v1 = 'NULL' line.

RE: NULL & 'NULL'

ronmoses — Thu, 04 Feb 2010 07:33:25 GMT

[quote][b]vitesh.bhana (2/4/2010)[/b][hr]For once in a long while, an uncontroversial answer :-)[/quote]Really! My favorite part of QotD is the ensuing argument! "I ran the script on 2005 Express with CONCAT_NULL_YIELDS_NULL set to OFF and I got a different result!!!" [i]That's[/i] when things get fun!(No, I didn't.)Ron Moses

RE: NULL & 'NULL'

vitesh.bhana — Thu, 04 Feb 2010 07:14:02 GMT

For once in a long while, an uncontroversial answer :-)

RE: NULL & 'NULL'

Bhavesh_Patel — Thu, 04 Feb 2010 05:35:54 GMT

Nice Question for Beginners ... :-)

RE: NULL & 'NULL'

vineitnarayansingh — Thu, 04 Feb 2010 02:43:51 GMT

Good post to understand the difference between 'NULL' and Null....;-)

RE: NULL & 'NULL'

jshailendra — Thu, 04 Feb 2010 00:03:11 GMT

very simple..but good Q for beginers

RE: NULL & 'NULL'

ziangij — Wed, 03 Feb 2010 23:38:57 GMT

simple one, thanks :-)

RE: NULL & 'NULL'

SQLRNNR — Wed, 03 Feb 2010 23:30:24 GMT

Thanks for the question.

NULL & 'NULL'

VM-723206 — Wed, 03 Feb 2010 21:40:35 GMT

Comments posted to this topic are about the item [B]NULL & 'NULL'[/B]