Interested to Buy Any Domain ? << Click Here >> for more details...
please bar with my english
i having a database called tblhallreservation in which
res_date is date field
has to select all the fields in table deponding on month
either has to display all details for the month jan or feb
and so on
- 1 Answers
- 3527 Views
- I also Faced
- E-Mail Answers
Answer Posted / kiran bala rath
select datename(mm,res_date),* from Tablename order by
convert(int,right(left(convert(varchar,res_date,105),5),2))
asc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define Business Edition in SQL Azure?
What stored by the master?
What the difference between UNION and UNIONALL?
Do you know query execution plan?
What are the differences between decimal and float in ms sql server?
What are the advantages of mirroring?
Which are the important points to note when multilanguage data is stored in a table?
What type of Index will get created after executing the above statement?
Explain relational data?
What will be query used to get the list of triggers in a database?
How many non clustered indexes there can be on table ?
How to use union to merge outputs from two queries together in ms sql server?
What is the recommended total size of your memory optimized tables?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What is the impact on other user sessions when creating indexes?
