-
Search parameters
MS SQL only, please.
Need a WHERE term that will return all the rows in the table thus:
Select * FROM Business
WHERE BusinessName =
What, placed after the equal sign, will return every row in the table? Spent all afternoon trying to figure this one out and haven't found it yet. This is the one needed to use the multiple search parameters.
Thanks in advance
-
Select * FROM Business
WHERE BusinessName = BusinessName
-
Don't use WHERE clause and it will return all rows
Select * FROM Business
if it must be used then any true condition can be used
Select * FROM Business
WHERE 1=1
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|