dbTalk Databases Forums  

Re: Reg where clause

microsoft.public.sqlserver.mseq microsoft.public.sqlserver.mseq


Discuss Re: Reg where clause in the microsoft.public.sqlserver.mseq forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Anith Sen
 
Posts: n/a

Default Re: Reg where clause - 07-09-2003 , 08:29 AM






There is no in-built mechanisms for doing that. If the sort order of a
specific attribute in an entity is important in your business model, your
logical model should capture & represent that information in your schema. In
SQL, this amounts to perhaps adding another column in your table which can
represent the required sort order. Then you can use this column in the ORDER
BY clause of your SELECT statement to get the rows sorted in your resultset.

--
- Anith
( Please reply to newsgroups only )



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.