What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
Answer Posted / niranjan prasad
There is no defference in result. It shows same result-set
by using both the command.This question put you to misguide
only.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is the distinction amongst delete and truncate?
Differentiate between delete and truncate.
Explain the different index configurations a table can have?
What is SQL Server?
Explain what are the basic functions for master, msdb, model, tempdb databases?
How to define output parameters in stored procedures?
How to set a database state to offline in ms sql server?
What is the web service used for reporting services?
How to test a dml trigger in ms sql server?
How to get all stored procedures in sql server?
What to perform pattern match with the like operator?
What stored by the master?
How we can compare two database data?
Comment,Datatypes are unlimited
What is a transaction and why is it important?