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
- 4946 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
How to list all stored procedures in the current database using ms sql server?
Tell me what is difference between clustered and non clustered index?
How to sort the query output with order by clauses in ms sql server?
In what three ways is the return statement used in a stored procedure?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
How can a database be repaired?
How you can move data or databases between servers and databases in sql server?
What are the difference between primary keys and foreign keys?
What is index fragmentation in ms sql server?
What are 3 ways to get a count of the number of records in a table?
What is difference between standardization and normalization?
In what version of sql server were synonyms released?
What is difference between index and primary key?
Tell me about normalization in DBMS.
What are the differences between stored procedure and view in sql server?
