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
- 3450 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
What is the language structure to add a record to a table?
What is the default server name for sql server?
Write a sql query to display the current date?
What is a trace frag?
Explain logical operators in sql server?
What are the advantages of mirroring?
How do you set a trace flag in sql server?
last function used in MS Access to convert sql what function will use in sql
How can I add Reporting Services reports to my application?
Write a sql query to delete duplicate records from a table called table1
What do you mean by sql server 2005 express management tools?
What is 3nf normalization form?
What is merge replication?
What is sleeping status in sql server?
What is db stored procedure?
