To register for an Internet.com membership to receive newsletters and white papers, use the Register button ABOVE.
To participate in the message forums BELOW, click here

HOME News MS SQL Oracle DB2 Access MySQL PHP Scripts Books Links DBA Talk


Go Back   Database Journal Forums > Miscellaneous > General Database Discussions
Reload this Page

Order By, using a variable

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

General Database Discussions Discuss any database topic not covered in any other forum on this site

Reply Post New Thread
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 11-22-2002, 03:00 AM
adamb adamb is offline
Junior Member
  
Join Date: Nov 2002
Posts: 2
Order By, using a variable
I have a stored procedure, and I'd like to pass it a parameter that tells me which field in a select clause to order my result set by. How do I do this?
Reply With Quote
  #2  
Old 11-22-2002, 09:34 AM
mist mist is offline
Member
  
Join Date: Oct 2002
Posts: 42
In Sql Server...


Read

http://www.sqlteam.com/item.asp?ItemID=2209

It will tell you how.
Reply With Quote
  #3  
Old 11-22-2002, 12:16 PM
adamb adamb is offline
Junior Member
  
Join Date: Nov 2002
Posts: 2
Smile Excellent, thank you...
This was right on point... and quick.

Thank you,

Adam
Reply With Quote
Reply Post New Thread

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Linear Mode Linear Mode
Rate This Thread:

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
Forum Jump


All times are GMT -5. The time now is 03:44 PM.

DatabaseJournal Recent Articles

 » Grouping with SQL Server 2008

 » Conducting Service Broker Conversation Usi...

 » SQL Server Consolidation Initiative Under ...

 » Transaction Log Growth, do you need it?

 » New FileMaker Pro 10 Ships With Sleek New ...

Search Database Journal:
 


Contact Us - Database Journal Forums - Top



Acceptable Use Policy

JupiterOnlineMedia

internet.comearthweb.comDevx.commediabistro.comGraphics.com

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info


Legal Notices, Licensing, Reprints, & Permissions, Privacy Policy.

Web Hosting | Newsletters | Tech Jobs | Shopping | E-mail Offers
Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.