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 / srinivas(6.3)

we cn write conditions until we get exact result ,tht we need

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is query and its types?

507


What is nonclustered index with included columns ?

542


Can you insert NULL in unique column?

618


Explain what is raid and what are different types of raid levels?

525


Why union all is faster than union?

502






What is acid properties?

583


what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

524


What is field with example?

508


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

474


What are different types of statements that are supported by sql?

588


What are recommended options to be used while using db mirroring? : sql server database administration

564


Is sql server difficult to learn?

515


How to Insert multiple rows with a single insert statement?

543


How can change procedure in sql server?

517


What area unit the various kinds of info compression introduced in sql server 2008?

564