which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM

Answer Posted / muhammadrashidmughal

select * from urTable
Where urDateColumn
Between '2007-10-20 17:00:00 PM'
and '2007-10-21 09:00:00 AM'

Is This Answer Correct ?    14 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to download and install sql server 2005 books online?

762


What triggers long term care?

716


What is the fillfactor concept in indexes?

724


Explain in brief about Microsoft SQL server?

729


What is perspective, have you ever created perspective? : sql server analysis services, ssas

673






What is unpivot?

777


What are the differences between “row_number()”, “rank()” and “dense_rank()”?

718


What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

893


What is a partitioned view?

769


Disadvantages of the indexes?

753


what are the three command line utilities and what are their primary functions?

119


what is database replication? : Sql server database administration

715


Explain in brief how sql server enhances scalability of the database system?

686


How can I tell if sql server is 32 or 64 bit?

707


What is CTE in SQL

706