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 7217

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 8084

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.

2042

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 8757

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 4175

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

HCL,

2 6345

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 7866

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 4823

What is the difference between local table and global table

CarrizalSoft Technologies, Polaris,

1 7397

What is SQL Profiler and the use of it?

247Customer,

2 4933

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

247Customer,

1 4621

What is the difference between truncate and delete statement?

CarrizalSoft Technologies, CTS,

6 8602

What is the difference between UNION and UNIONALL?

CarrizalSoft Technologies, CTS,

5 13742

WHAT OPERATOR PERFORMS PATTERN MATCHING?

CarrizalSoft Technologies, CTS,

2 7272

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

CarrizalSoft Technologies, CTS, Oracle,

5 11641

Un-Answered Questions { SQL Server }

Mention the differences between having and where clause.

1009

Explain transaction server distributed transaction?

936

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

972

What is the definition for sql server 2000?

1048

Why would you call update statistics?

972

Differentiate between ms sql server reporting services vs crystal reports?

857

What are three major types of constraints?

1059

what protocol both networks use? : Sql server database administration

943

Explain about the command-line tool SQLCMD?

1033

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

967

What is scd (slowly changing dimension)? : sql server analysis services, ssas

961

Can sub report data source be different from that of the parent report?

137

How many types of schemas are there?

981

Why should one not prefix user stored procedures with ‘sp_’?

999

What do you understand by triggers?

872

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