SQL Server Interview Questions
Questions Answers Views Company eMail

Why we need a group by clause?

4 8673

What is a join and their types?

Challenger Financial,

2 6413

What is the difference between referencing and joining?

1 3277

What is the difference between constraints and triggers?

Wipro,

9 33317

What is ACID Property of Transaction?

10 34786

What is an index?

Yardi Software,

8 13122

What is normalization and its forms?

Challenger Financial,

4 12510

What is a cursor in SQL Server 2000 and their types?

8 16727

How do we get month name in SQL Server 2000, Oracle, MS Access?

11 50793

How do we return a record set from a Stored Procedure in SQl server 2000?

3 5349

What are the magic tables in SQL Server 2000?

Infogain, Merrill Lynch,

7 23136

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 49002

What are the differences between stored procedure and functions in SQL Server 2000?

College School Exams Tests, HCL, Infosys, TCS,

25 105816

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 5393

Which is best Subquery (or) joins in sql server? explain why

2 10237


Un-Answered Questions { SQL Server }

What is proper subset of candidate key?

529


How to rebuild indexes with alter index ... Rebuild?

564


What do you understand by triggers and mention the different types of it?

461


How to delete multiple rows with one delete statement in ms sql server?

493


Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

558






Why normalization is used?

528


What is model database? : SQL Server Architecture

546


What happens if the update subquery returns multiple rows in ms sql server?

567


What does this statement do @@rowcount?

526


Explain the concepts and capabilities of sql server?

521


What part does database design plays a role in performance of an sql server-based application?

494


What is cursors?

619


Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

492


How to delete database objects with "drop" statements in ms sql server?

572


Why is sql server log file full?

508