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
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
Is sql server free?
Can we use custom code in ssrs?
How to define the name and server for a new dsn?
What is the use of nvl work?
What is the default value of an integer data type in sql server 2005?
How many types of database relationship in sql server?
Call by value and call by reference in procedure and function, with NOCOPY.
What is the difference between a view and a stored procedure?
Can we add our custom code in ssis?
What are the transaction properties?
What does dml stand for?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How many triggers you can have on a table?
Difference between Sql server reporting services and Crystal reports?
what are defaults? : Sql server database administration