REGISTER
|
Search Tycoon Talk
|
Freelancer.com
|
Members
Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.
Register Here
Forum Rules
The Database Forum
You are currently viewing our The Database Forum as a guest. Please
register
to participate.
Login
Remember Me?
Login via Freelancer.com
Tycoon Talk
>
Web Administration Support
>
The Database Forum
>
Top N vs RowCount
Link Back
Thread Tools
Search this Thread
Top N vs RowCount
07-17-2008, 02:57 PM
#
1
(
permalink
)
Top N vs RowCount
Learning Newbie
Defies a Status
Latest Blog Post:
Astounding Republican Paranoia
Posts: 5,662
Name: John Alexander
Trades:
0
Talkupation:
Which do people prefer, and why? Obviously, if you need a particular N rows, you use Top N, and if you need the value to be configurable, you use RowCount, but how do you make this decision when neither of those are a requirement?
__________________
Please login or register to view this content.
Registration is FREE
Please login or register to view this content.
Registration is FREE
Register
now for full access!
07-21-2008, 05:06 AM
#
2
(
permalink
)
Re: Top N vs RowCount
vividearth
Experienced Talker
Posts: 33
Location: London, UK
Trades:
0
Talkupation:
TOP for me just for simplicity (plus can use percent). Only time I would use rowcount is if I need to set the value dynamically in stored proc.
__________________
Please login or register to view this content.
Registration is FREE
Please login or register to view this content.
Registration is FREE
Please login or register to view this content.
Registration is FREE
« Reply to
Top N vs RowCount
Previous Thread
|
Next Thread
Tycoon Talk
>
Web Administration Support
>
The Database Forum
>
Top N vs RowCount
Thread Tools
Search this Thread
Show Printable Version
Email this Page
Search this Thread
:
Advanced Search
Posting Rules
You
may not
post new threads
You
may not
post replies
You
may not
post attachments
You
may not
edit your posts
BB code
is
On
Smilies
are
On
[IMG]
code is
On
HTML code is
Off
Trackbacks
are
Off
Pingbacks
are
Off
Refbacks
are
Off
Forum Rules
Feeds:
RSS
JS
XML
Feeds for this forum:
RSS
JS
XML
LinkBack
LinkBack URL
About LinkBacks
Bookmark & Share
Digg this Thread!
Add Thread to del.icio.us
Bookmark in Technorati
Tweet this thread
Page generated in
0.23746
seconds with
12
queries