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

Answer Posted / sandeep rana

select * from table where columndata not in(select
columndata from table where date between '' and '')

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are types of storage modes? : sql server analysis services, ssas

586


What are the different types of lock modes in sql server 2000?

491


What is difference between equi join and natural join?

543


How to use go command in "sqlcmd"?

647


Can a rule be bound to any column of any data type?

573






How can you manage sql azure security?

85


Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

575


How to choose all records from the table?

659


What is the largest component inside a field?

534


Write a program to fetch first 10 records from a file?

607


what is a mixed extent? : Sql server administration

607


What is the sql profiler?

545


Do you know query execution plan?

589


What is 4nf in normalization form?

573


What is difference between getdate and sysdatetime in sql server 2008?

603