SQL Server Interview Questions
Questions Answers Views Company eMail

Why we need a group by clause?

4 6681

What is a join and their types?

Challenger Financial,

2 5088

What is the difference between referencing and joining?

1 2317

What is the difference between constraints and triggers?


9 25392

What is ACID Property of Transaction?

10 30051

What is an index?

Yardi Software,

8 9841

What is normalization and its forms?

Challenger Financial,

4 10458

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

8 13750

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

11 45754

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

3 3732

What are the magic tables in SQL Server 2000?

Merrill Lynch, Infogain,

7 20073

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

13 43289

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

Infosys, HCL, TCS, College School Exams Tests,

25 96654

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 3807

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

2 9020

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

what are the Prerequisites for Replication?


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


How to convert a table data in XML format in sql server?


my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions


How to restore performance issues and how to check?


New concepts of sql server 2005 use in your project.


what exactly sql injuction.how to overcome.....


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?


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


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it


Delete duplicate rows without using rowid.


ow to bring suspect mode datbase online from scratch


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?


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


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible