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 7289

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 8236

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.

2071

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 9009

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 4273

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

HCL,

2 6446

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 8031

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 4949

What is the difference between local table and global table

CarrizalSoft Technologies, Polaris,

1 7472

What is SQL Profiler and the use of it?

247Customer,

2 5035

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

247Customer,

1 4697

What is the difference between truncate and delete statement?

CarrizalSoft Technologies, CTS,

6 8862

What is the difference between UNION and UNIONALL?

CarrizalSoft Technologies, CTS,

5 13944

WHAT OPERATOR PERFORMS PATTERN MATCHING?

CarrizalSoft Technologies, CTS,

2 7390

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

CarrizalSoft Technologies, CTS, Oracle,

5 11817

Un-Answered Questions { SQL Server }

What are the differences between char and varchar in ms sql server?

1063

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1606

Is null in sql server?

988

What is the most common trace flags used with sql server?

1042

What is CTE in SQL

945

What is resource governor in sql server?

995

what is the information that can be stored inside a bit column? : Sql server database administration

963

What is transactional replication?

967

Explain what are various ways to enhance the ssrs report?

1044

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

982

How can I know what locks are running on which resource?

957

Can you explain important index characteristics?

991

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1135

How many types of schemas are there?

1041

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1075

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