What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table
Post New Answer View All Answers
What are the different methods available under sqlcommand class to access the data?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
How do I view a script in sql server?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
Differentiate between a having clause and a where clause.
Can a table have 2 primary keys?
What are the properties and different types of sub-queries?
What are the basic functions for master, msdb, model, tempdb and resource databases?
What is update locks?
What is the definition for sql server 2000?
What causes index fragmentation?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Explain difference between control flow and data flow?
what data regions are and what are the different data regions?