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

create table with fields ID, reserved_by,res_date
res_date is datefield like 2010-03-09 00:00:00.000 from
2005 to 2006 any date assume
based on res_date need to slect table and display
based on month (full jan details in database irrespective
of date and year

Question Posted / mahe_87

Answers were Sorted based on User's Feedback



create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.0..

Answer / sandip

//Show records for a given month
SELECT * FROM table_name (NOLOCK)
WHERE SUBSTRING(res_date, 6, 2) = (numeric value for month.
eg 01 for Jan)


//Show all the records sorted by res_date based on month.
SELECT * FROM table_name (NOLOCK)
ORDER BY SUBSTRING(res_date, 6, 2) ASC

Is This Answer Correct ?    3 Yes 0 No

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.0..

Answer / thangas sujith prabu.s

select * from tablename where res_date>'2010-01-01
00:00:00.000' and res_date<'2010-02-01 00:00:00.000'

Is This Answer Correct ?    2 Yes 1 No

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.0..

Answer / anilkumar manthena

select * from <Table> where datepart(month,res_date)=1
It will return all the reservations made on Month "January".

Ex:
SELECT DATEPART(month, '2009-02-13 18:35:06.523')
retrieves the value 2.

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More SQL Server Interview Questions

How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005

2 Answers  

What is delete query?

0 Answers  

Why I am getting this error when dropping a database in ms sql server?

0 Answers  

How to edit table in sql server 2017?

0 Answers  

What is a Trace frag?Where can we use this?

1 Answers  

What do you mean by the term 'normalization'?

0 Answers   Tech Mahindra,

what are the critical issues you have resloved in your company

0 Answers   Wipro,

Why do we use sql limitations? Which constraints can we use while making a database in sql?

0 Answers  

How to modify existing triggers using "alter trigger"?

0 Answers  

what are constraints? Explain different types of constraints? : Sql server database administration

0 Answers  

What is a View ? Can we insert, Update and delete a view?

0 Answers   Arigo Infotech,

What is normalization and its types?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories