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
- 49810 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / naren
No difference
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
List the different types of joins?
how you can configure a running aggregate in SSRS?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
Mention the different authentication modes in sql server.
How to generate random numbers with the rand() function in ms sql server?
Can select statements be used on views in ms sql server?
Can you please differentiate between a primary key and a unique key?
How do you know if sql server is running on your local system?
How to declare and use cursor variables?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
How to create indexed view?
Explain some stored procedure creating best practices or guidelines?
Do you know what is user defined datatypes and when you should go for them?
How to optimize stored procedures in sql server?
What are the properties of primary key?
