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

Why use “in” clause in sql server?

1071

Write an sql query to find the names of employees start with ‘a’?

1 1746

When would you use it?

994

What is the difference between ‘having’ clause and a ‘where’ clause?

1040

How to add code to the existing article (using improve article)?

1110

Explain about link server in sql server?

1059

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 2040

What is the difference between delete and truncate statements?

1083

Explain foreign key in sql server?

1030

What is a field in a table?

1041

What are a scheduled jobs or what is a scheduled tasks?

903

List the different types of joins?

1008

What is the difference between char and varchar2 datatype in sql?

1066

What are entities and relationships?

975

What is the difference between dropping a database and taking a database offline?

1174

Un-Answered Questions { SQL Server }

What is ms sql server triggers?

1012

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1011

What is an entity-relationship diagram (erd)?

1213

What command must you use to include the not null constraint after a table has already been created?

1146

What is sql or structured query language?

1151

What is resource governor in sql server?

996

Can you explain about buffer cash and log cache in sql server?

948

What are the types of sql server?

1052

What is used to replicate sessions between instances in coldfusion clusters?

1072

What is a mutating table error and how can you get around it?

1050

Which tcl commands are available on the sql server?

1083

What are the differences between lost updates and uncommitted dependencies?

1078

How do you send email on SQL Server?

1064

Can an entity have two primary keys?

981

What is shrink log file?

897

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