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?

Wipro,

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?

8605


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

4826


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

1440


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

907


How to restore performance issues and how to check?

883






New concepts of sql server 2005 use in your project.

1266


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

1336


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?

656


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

865


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

350


Delete duplicate rows without using rowid.

231


ow to bring suspect mode datbase online from scratch

724


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

1341


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

889


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

1148