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
- 3483 Views
- I also Faced
- E-Mail Answers
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 operating modes in which database mirroring runs?
How cand Optimize SQL Server Stored Procedures
What is page-level compression?
what is mean by crystal repoart? ahere we will mainly use that?
What are the differences between char and varchar in ms sql server?
What do you understand by the data quality services in sql server?
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
How will you decide the active and passive nodes?
What is sub-query in sql server?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What is a transaction and what are ACID properties?
-
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)
