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

What are the disadvantages of merge replication?

0 Answers  

How do you send email on SQL Server?

0 Answers   MindCracker,

How do I connect to sql server database?

0 Answers  

What are the disadvantages of primary key and foreign key in SQL?

0 Answers   Alcatel-Lucent,

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

0 Answers   HP,

What is a performance monitor?

0 Answers  

Where are sql server usernames and passwords stored in the sql server?

0 Answers  

What is the difference between DATETIME2 and DATETIME?

0 Answers   Infosys,

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

0 Answers   IBM,

What are the differences between triggers and stored procedures?

0 Answers  

List the different types of joins?

0 Answers  

write down the code for "how we delete a table without using of Drop command " ?

7 Answers   CarrizalSoft Technologies, Sonata,

For more SQL Server Interview Questions Click Here
Categories