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
- 49776 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / kohulavani.g
First query,in table where 1=1 condition is satisfied that
row or column is displayed
But in second query,the whole table is displayed
| Is This Answer Correct ? | 18 Yes | 44 No |
Post New Answer View All Answers
How to connect of datebase with sql express.?
What is database isolation in sql server? : sql server database administration
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Define master database?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What are the approximate numeric data types?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
What is data compression? : sql server database administration
Explain how to send email from sql database?
Is sql different from sql server?
What is index, cluster index and nonclustered index?
What is self contained scalar sub query?
What is recompile sql server?
explain different types of joins? : Sql server database administration
Why would you call update statistics?
