SQL Server Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

SSRS SQL Server Reporting Services (140)
Microsoft Azure SQL (73)

SQL Server Interview Questions

Questions Answers Views Company eMail

What is Index Segmentation ?

1 7287

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 8218

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2066

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 8976

CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.

2 4267

which one will take 1st priority in case of insert statement and select statement???

HCL,

2 6433

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

Aptech,

5 8026

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

247Customer,

2 4941

What is the difference between local table and global table

CarrizalSoft Technologies, Polaris,

1 7466

What is SQL Profiler and the use of it?

247Customer,

2 5028

What are SQL Jobs, please mention the use of it and how to create them.

247Customer,

1 4691

What is the difference between truncate and delete statement?

CarrizalSoft Technologies, CTS,

6 8831

What is the difference between UNION and UNIONALL?

CarrizalSoft Technologies, CTS,

5 13936

WHAT OPERATOR PERFORMS PATTERN MATCHING?

CarrizalSoft Technologies, CTS,

2 7386

What is the order in which the SQL query is executed? list them in order.

CarrizalSoft Technologies, CTS, Oracle,

5 11792

Un-Answered Questions { SQL Server }

Define clusters?

1058

What is indexing a document?

1031

What are transactions in sql?

1056

Name some of the open source software that you can use in alternative to SSR?

159

Give an example of why you would want to denormalize a database

974

What is cursors? And what are the different types of cursor?

1141

What is the difference between varchar and nvarchar?

939

What are functions in the sql server?

1208

How each E-R model constructs can be mapped to the relational model?

996

How to replace given values with null using nullif()?

983

What is a trigger what are the advantages of trigger?

995

Does sql server use t sql?

1015

Explain data warehousing in sql server?

1040

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1104

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

1000

For More Un-Answered { SQL Server } Questions Click Here