What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
Post New Answer View All Answers
how many no of arguments can be passed in procedures and functions
What are the basic functions for master, msdb, model, tempdb databases?
What is SQL Azure Firewall?
Explain syntax for viewing trigger?
What is the function of inner join?
Can you use order by when defining a view?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
Define outer join in sql server joins?
Do you know what guidelines should be followed to help minimize deadlocks?
What are partitioned views and distributed partitioned views?
What are the types of sql server?
What is difference between stored procedure and user defined function?
Explain powershell included in sql server 2008?
What structure can you implement for the database to speed up table reads?
What are the different ways you can create databases in sql server?