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
What is the function of sql server agent windows service?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
What are the steps to insert a table?
Tell me what is fill factor?
What are the differences between web role and worker role?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
how many layers of tcp/ip protocol combined of? : Sql server database administration
What is a data source or ds? : sql server analysis services, ssas
Will count(column) include columns with null values in its count?
Explain the xml support sql server extends?
When we should use @@error?
How you can find out if an index is useful to the optimizer?
What stored by the model?
What is bookmark link in ssrs?
Can you explain various data region available in ssrs with their use?