Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 5032 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What does ss stand for sexually?
What is meant by indexing?
How to name query output columns in ms sql server?
can a database be shrunk with users active? : Sql server administration
how you can move data or databases between servers and databases in sql server? : Sql server administration
Do I need a report server to run reports in my application?
Explain encryption of entire databases without the need for application changes in sql server 2008?
Explain the microsoft sql server delete command? : SQL Server Architecture
define and explain the differences between clustered and non-clustered indexes.
What is a View ? Can we insert, Update and delete a view?
how can you check the level of fragmentation on a table? : Sql server administration
How to create a new login name in ms sql server?
What is transaction server distributed transaction?
Do you know what are the restrictions that views have to follow?
Is a primary key unique?
