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?

Wipro,

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?

936


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

756


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

630


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

848


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

814






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

2610


Issues related in upgrading SQL Server 2000 to 2005 / 2008

740


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?

835


New concepts of sql server 2005 use in your project.

1211


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

825


application server is slow what may be the problem

1065


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

4721


How to restore performance issues and how to check?

812


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

800


What is data modeling and Reterminal integrity?

633