Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
- 17 Answers
- 49324 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / kohulavani.g
First query,in table where 1=1 condition is satisfied that
row or column is displayed
But in second query,the whole table is displayed
| Is This Answer Correct ? | 18 Yes | 44 No |
Post New Answer View All Answers
How to connect sql server management studio express to sql server 2005 express?
How to generate create procedure script on an existing stored procedure?
What do I need to start working with sql studio? : sql server management studio
What is the difference between functions and scalar functions?
Which autogrowth database setting is good?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What is the process of normalization?
Tell me about the approaches which you used to counter the DI problems.
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
How do I completely remove sql server instance?
Is truncate a dml command?
What is the default sql server instance name?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is a hint?
