What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
Answer Posted / naren
No difference
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How do I create an extended event in sql server?
Explain Reporting Life Cycle?
Where can you find the error log information? : sql server database administration
Differentiate between truncate vs delete in mssql?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What is sharding?
What is an index. What are the types?
What is temporary stored procedure?
Do you know the capabilities of cursors?
What is Service Broker in sql server 2012?
Explain what is use of dbcc commands?
What is the difference between join and inner join?
What is NOT NULL Constraint in sql server 2012?
What is the main difference between ‘between’ and ‘in’ condition operators?
How to list all stored procedures in the current database using ms sql server?