please bar with my english i having a database called tblhallreservation in whi

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

1 Answers
2733 Views
I also Faced
E-Mail Answers

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 is extent? Types of extents?

0 Answers

Explain about Normalization?

0 Answers Infosys,

What is full outer join in sql server joins?

0 Answers

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers Microsoft,

how we can use a database with php.

2 Answers HCL, IT Solution,

How to provide values to stored procedure parameters in ms sql server?

0 Answers

Explain about SQLOS?

0 Answers

What is t-sql script to take database offline – take database online.

0 Answers

What types of Joins are possible with Sql Server?

0 Answers NA,

What are the basic functions for master, msdb, model, tempdb and resource databases?