which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM
- 5 Answers
- 10628 Views
- Wipro, I also Faced
- E-Mail Answers
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
Tell me when is the update_statistics command used?
What is nolock hint in sql server 2008
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What is the difference between ‘having’ clause and a ‘where’ clause?
What is attribute? : sql server analysis services, ssas
Explain about Normalization?
What is self join in sql server joins?
Explain the dbcc pintable command when would you use it?
What are a scheduled jobs?
How do you test your database? : sql server database administration
State the difference between local and global temporary tables?
What is a hint?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What are the types of database schema? : sql server analysis services, ssas
How to retrieve error messages using mssql_get_last_message()?
