SET 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 » SET ROWCOUNT and table variable

55 posts, Page 1 of 6

1 2 3 4 5 »»»

SET ROWCOUNT and table variable

Rate Topic

Display Mode

Topic Options

Author

Message

Carlo Romagnano

Posted Wednesday, August 25, 2010 8:40 PM

SSCommitted

Group: General Forum Members
Last Login: Today @ 12:54 AM
Points: 1,969, Visits: 1,820

Comments posted to this topic are about the item SET ROWCOUNT and table variable

Post #975310

Oleg Netchaev

Posted Wednesday, August 25, 2010 8:51 PM

SSCommitted

Group: General Forum Members
Last Login: Today @ 10:53 AM
Points: 1,662, Visits: 1,709

This is an excellent question, thank you. I answered it correctly because for years I cannot find the answer to the following question: why would anyone ever consider casually using float data type? I understand that there might be some specific scenarios where the inaccuracy of calculations are not important and the range of the numbers is huge, but using float for no good reason is astonishingly bad not to say plain silly. The query in Qotd is one fine example demonstrating this point.

Oleg

Post #975312

UMG Developer

Posted Wednesday, August 25, 2010 9:57 PM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163, Visits: 2,148

Thanks for the question, I had to puzzle it out for a while, but got it right.

Post #975324

malleswarareddy_m

Posted Wednesday, August 25, 2010 10:47 PM

SSCommitted

Group: General Forum Members
Last Login: Today @ 12:06 AM
Points: 1,846, Visits: 974

for testing folating point the same can be written as

DECLARE @i float,@rc int
set @i = 0
while @i <> 1
begin
set @i = @i + 0.1
end
select @i

then the loop never executes.

I observer some intrested behavior of floating point

DECLARE @i float,@rc int
set @i = 0
while @i <> 1
begin
set @i = 0.8999 + 0.1
end
select @i

the above will never executes. we use 0.1 instead of 0.8999 other wise we can use 0.2,0.3,0.4,0.5,0.6,0.7,0.8.but when i added 0.9 it executes

and show 1 as answer.

Malleswarareddy
I.T.Analyst
MCITP(70-451)

Post #975345

mccork

Posted Wednesday, August 25, 2010 10:54 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 10:32 PM
Points: 4,591, Visits: 321

The answer was almost obvious from the "do not run it on production server" recommendation.

But, a good question for highlighting the pitfalls of "float".

Cheers,
- Mark

Post #975349

Stewart "Arturius" Campbell

Posted Wednesday, August 25, 2010 11:42 PM

Hall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:48 AM
Points: 3,125, Visits: 4,311

The only possible use for the float datatype that I have found is in the calculations used in astro-physics, where the distance between stars and galaxies is an approximation, at best

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #975366

SQLRNNR

Posted Thursday, August 26, 2010 12:32 AM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:07 PM
Points: 18,733, Visits: 12,332

Thanks for a great question.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #975384

Koen Verbeeck

Posted Thursday, August 26, 2010 1:03 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Today @ 7:39 AM
Points: 9,370, Visits: 6,467

Great question. I got it wrong though. I do not really understand how the scope of the type variable works. It seems you can define it over and over again, without an error being thrown?

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.