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 / 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 |
What are the disadvantages of merge replication?
How do you send email on SQL Server?
How do I connect to sql server database?
What are the disadvantages of primary key and foreign key in SQL?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
What is a performance monitor?
Where are sql server usernames and passwords stored in the sql server?
What is the difference between DATETIME2 and DATETIME?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What are the differences between triggers and stored procedures?
List the different types of joins?
write down the code for "how we delete a table without using of Drop command " ?
7 Answers CarrizalSoft Technologies, Sonata,
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)