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
- 49151 Views
- HP, I also Faced
- E-Mail Answers
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
When a primary key constraint is included in a table, what other constraints does this imply?
What are the purposes and advantages stored procedure?
Why truncate is ddl command?
How column data types are determined in a view?
What is collation sensitivity? Explain different types.
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Explain what is the use of custom fields in report?
Do you know what is normalization of database? What are its benefits?
How to check table values in sql server?
Can binary strings be converted into numeric or float data types?
Can a table be created inside a trigger?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
how can you attach more than 20 ldf files in sql server
When would you use it?
how to do partition in sqlserver
