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 / raj

23

Is This Answer Correct ?    6 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to make a column nullable?

592


what stored procedure can you use to display the current processes? : Sql server administration

528


What objects does the fn_my_permissions function reports on? : sql server security

551


When to use Inner join & when to use subquery?

574


How to use subqueries with the exists operators in ms sql server?

580






what is the difference between Delete and Truncate command in SQL

622


How fixed length strings are truncated and padded?

544


What is ems sql management studio? : sql server management studio

583


You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

110


What is the difference between dbcc indexdefrag and dbcc reindex?

515


What are the different types of backups that exist?

674


How to delete all rows with truncate table statement in ms sql server?

482


What command would you use to add a column to a table in sql server?

742


Define views.

585


Define left outer join?

573