Sign Up Login


  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

Can we linked SharePoint to a SQL database?

0 Answers   Sans Pareil IT Services,

how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,

What are the extra roles available in msdb? : sql server security

0 Answers  

How to work on DTS?what is the main requirement?

1 Answers   Getit, ivan,

What are character string data types in ms sql server?

0 Answers  




Does a sql server 2005 select statement require a from?

0 Answers  

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

What is difference between temp table and cte?

0 Answers  

explain different types of backups avaialabe in sql server? : Sql server database administration

0 Answers  

How do I start sql server 2016?

0 Answers  

Explain full-text indexing?

0 Answers  

What are the types of stored procedures in an sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories