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
- 49773 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / krishna sandeep
Of course, both the Queries will get you the same data but,
When compared to the first case processing time will be
slightly reduced in the second case.
Bytes sent from client and Bytes received from server will
be more in the first case.
and one more thing is better not using "select * from ..."
| Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
How do you check sql server is up and running?
What are the different sql server versions?
Which are ddl commands?
What is nolock hint in sql server 2008
how you can deploy an ssrs report?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
Explain primary key and foreign key constraints?
What is the purpose of the tempdb database?
What is 1nf normalization form?
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?
What new changes are being made in SQL Server?
How do I edit a procedure in sql server?
Is it important for a database administrator to understand the operating system and file access?
What is a trigger? Why we need it?
Can we write trigger for view?
