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
What is a trace frag? Where do we use it?
What does it mean to invest in the index?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What is sqlcmd?
How to divide query output into multiple groups with the group by clause in ms sql server?
What are the differences between decimal and float in ms sql server?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
How to generate create table script on an existing table in ms sql server?
Do you think BCNF is better than 2NF & 3NF? Why?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What is 'write-ahead log' in sql server 2000 ?
When we should use and scope of @@identity?
List some of the rules that apply to creating and using a ‘view’
what's the maximum size of a row? : Sql server database administration
what is the difference between count(*) and count(1) ?