In QotD, posted on Aug 6 on ROWCOUNT and table variable

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Carlo Romagnano » In QotD, posted on Aug 6 on ROWCOUNT and...

In QotD, posted on Aug 6 on ROWCOUNT and table variable

Rate Topic

Display Mode

Topic Options

Author

Message

Gopi S

Posted Friday, August 27, 2010 3:45 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, May 02, 2013 11:47 AM
Points: 151, Visits: 277

Hi,
Pls help me on this. In QotD, question posted on Aug 6 on ROWCOUNT, the answer in infinite loop. ie, the condition @i <> 1 always is true . But another sample query as shown below gives expected result which contradicts from while loop.

DECLARE @i float
set @i = .9
set @i = @i + .1

-- Query 1
if @i <> 1
print 'Yes'
else
print 'No'

Answer: No

-- Query 2
if @i = 1
print 'Yes'
else
print 'No'

Answer: Yes

Can anyone pls explain on difference in this two.

Post #976247

« Prev Topic | Next Topic »

Permissions