What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
Answer Posted / rohit nanda
NO DIFFERENCE IN BOTH THE EQUATION...BCOZ THEY GIVE THE SAME
OUTPUT....
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How do I find sql server instance name?
What is a user-defined function in the sql server and what is its advantage?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Explain the difference between HTTP and HTTPS in database?
What command do we use to rename a database?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
Write an sql query to find first weekday of the month?
What is table join?
whats new about truncate in sql server 2008?
What is side by side migration in sql server?
What is parameterized reports in ssrs ?
What is system stored procedures?
Describe triggers features and limitations?
How do you make a trace?
What is nested transaction?