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
- 50369 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / g.nageswara rao
in first query 1=1 always true,then it retrives all columns
in a table.
so,there is no difference in between these two
| Is This Answer Correct ? | 39 Yes | 3 No |
Post New Answer View All Answers
How to create database with physical files specified in ms sql server?
What is a user-defined function in the sql server and what is its advantage?
Name few of the dcl commands in sql?
What is the sql server 2000 version number?
What is 3nf normalization?
What command do we use to rename a db, a table and a column?
What different steps will a sql server developer take to secure sql server?
Which rendering formats are affected by the pagesize properties?
Explain what is the difference between a local and a global temporary table?
What do you understand by triggers and mention the different types of it?
What is raid and what are different types of raid levels?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
How to download and install microsoft .net framework version 2.0?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
