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 7352

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 8395

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.

2116

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 9252

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 4387

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

HCL,

2 6525

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 8213

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 5054

What is the difference between local table and global table

CarrizalSoft Technologies, Polaris,

1 7545

What is SQL Profiler and the use of it?

247Customer,

2 5144

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

247Customer,

1 4780

What is the difference between truncate and delete statement?

CarrizalSoft Technologies, CTS,

6 9104

What is the difference between UNION and UNIONALL?

CarrizalSoft Technologies, CTS,

5 14152

WHAT OPERATOR PERFORMS PATTERN MATCHING?

CarrizalSoft Technologies, CTS,

2 7513

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

CarrizalSoft Technologies, CTS, Oracle,

5 12015

Un-Answered Questions { SQL Server }

How can you fetch alternate records from a table?

1016

What is an execution plan? How would you view the execution plan?

1131

What are the basic functions for master, msdb, model, tempdb and resource databases?

1037

What is report snapshot in ssrs?

280

What is the difference between count and distinct count?

933

Explain user defined functions?

1047

What are the differences between sql server and mysql.

1146

What are the advantages of sql stored procedure?

1125

How to execute a sql statement using mssql_query()?

1105

Why should you use or avoid select * statements?

1078

What happens when unicode strings concatenate with non-unicode strings?

1187

What happens if you insert a duplicate key for the primary key column in ms sql server?

1027

What is forward - only cursors / read only cursor?

1134

What is the difference between commit and rollback?

993

What are unicode character string data types in ms sql server?

1346

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