How many max. conditions can b written under the WHERE
clause?

Like select * from [tabnam] WHERE
(cond1...or..cond2....or...cond3...and.....so on.....???
(upto how much extent))?????

Answer Posted / student

This question doesn't make any sense.

Do you mean

select * from table
where...
and...
and...
and...
and...
and...
and...
or..
or..
or..
or..
or..

etc.?

Is This Answer Correct ?    10 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Call by value and call by reference in procedure and function, with NOCOPY.

1045


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1687


What is standby servers? Explain types of standby servers.

675


What is ms sql server service broker?

684


How would you use user_constraints table in DB?

750






Please illustrate physical database architecture? : SQL Server Architecture

741


How do you run a trace?

690


What is sql server locking?

704


What is the stuff?

711


Can I work with several databases simultaneously? : sql server management studio

737


How to join two tables in a single query in ms sql server?

717


how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

784


Can you always create a cache of a report?

145


What are acid properties of transaction?

693


How many databases Microsoft SQL server provides?

782