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 a subquery in a select query statement in ms sql server?

1131

How to see the event list of an existing trigger using sys.trigger_events?

1073

How to provide default values to stored procedure parameters?

1065

How to defragment indexes with alter index ... Reorganize?

1087

What is the default schema of your login session in ms sql server?

1049

Where to find ntwdblib.dll version 2000.80.194.0?

962

What happens if ntwdblib.dll is missing on your machine?

1144

How to disconnect from a sql server using mssql_close()?

1109

How to turn on the mssql api module in php?

1078

Can select statements be used on views in ms sql server?

1065

How to create a ddl trigger using "create trigger" statements?

1131

How to use old values to define new values in update statements in ms sql server?

1266

Does index speed up select statements?

1011

What happens if time-only values are provided as date and time literals?

1017

Is the order of columns in the set clause important in ms sql server?

968

Un-Answered Questions { SQL Server }

Can we write a distributed query and get some data which is located on other server and oracle database?

1231

explain databases and sql server databases architecture? : Sql server database administration

960

What is difference between unique and primary key?

913

How to set a database state to offline in ms sql server?

1046

How to use subqueries with the exists operators in ms sql server?

1119

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

972

Tell me the phases a transaction has to undergo?

962

What is the correct order of the logical query processing phases?

936

In what sequence sql statement is processed?

1012

When do you think a developer should use sql server-based cursors?

1047

What does COMMIT command do?

1063

How to create a user to access a database in ms sql server using "create user" statements?

950

List some of the rules that apply to creating and using a ‘view’

888

What are different types of replication in sql server?

1084

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

1002

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