SQL Server Interview Questions
Questions Answers Views Company eMail

Why we need a group by clause?

4 6567

What is a join and their types?

Challenger Financial,

2 4972

What is the difference between referencing and joining?

1 2214

What is the difference between constraints and triggers?


9 24779

What is ACID Property of Transaction?

10 29725

What is an index?

Yardi Software,

8 9633

What is normalization and its forms?

Challenger Financial,

4 10225

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

8 13589

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

11 45512

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

3 3582

What are the magic tables in SQL Server 2000?

Merrill Lynch, Infogain,

7 19844

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

13 42908

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

Infosys, HCL, TCS, College School Exams Tests,

25 96121

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 3684

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

2 8891

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

What is best institute to Learn DotNET And SQL in chennai?


how to use DTS package in 2000,2005,2008 in sql server


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do


Which is the best place or learning center for MS SQL?????In Bangladesh?????


on line cluster can we make if yes tell me the procedure


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?


Issues related in upgrading SQL Server 2000 to 2005 / 2008


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?


New concepts of sql server 2005 use in your project.


last function used in MS Access to convert sql what function will use in sql


application server is slow what may be the problem


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?


How to restore performance issues and how to check?


how can you attach more than 20 ldf files in sql server


What is data modeling and Reterminal integrity?