Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / guest


please bar with my english i having a database called tblhallreservation in which res_date is dat..

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

Post New Answer

More SQL Server Interview Questions

event classes in sql server

2 Answers   Accenture, AFE,

What is plan freezing?

0 Answers  

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

What is the largest component inside a field?

0 Answers  

What is a mixed extent?

0 Answers  

How to use the inserted and deleted pseudo tables?

0 Answers  

What are the main sources of data?

0 Answers  

How would you add a section to a table?

0 Answers  

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

0 Answers  

How to Install SQL SERVER 2005 remotely?

1 Answers   IBM,

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers  

Can sql servers linked to other servers?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories