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

How to find the login name linked to a given user name?

1004

How to rename databases in ms sql server?

1187

How to select all columns of all rows from a table with a select statement in ms sql server?

1104

How to create a dml trigger using create trigger statements?

1026

How to set database to be read_only in ms sql server?

1000

What is the simplest way to create a new database in ms sql server?

1002

How to connect ms access to sql servers through odbc?

1018

How to add an address record into adventureworkslt?

984

How to select some specific rows from a table in ms sql server?

999

How to create a new schema in a database?

1138

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

971

How to define the name and server for a new dsn?

1101

How to create a trigger for insert only?

1031

How to delete a login name in ms sql server?

1065

What are the differences between decimal and float in ms sql server?

1230

Un-Answered Questions { SQL Server }

Do you know what guidelines should be followed to help minimize deadlocks?

968

What is the use of stored procedure?

933

What are the restrictions that views have to follow? : SQL Server Architecture

989

Explain the collation?

1102

What is the full meaning of dml?

945

What do you know about system database? : SQL Server Architecture

978

What is replication and database mirroring?

1040

Tell me what is normalization? Explain different forms of normalization?

1026

How you can change the database name in SQL SERVER?

1188

What purpose does the model database server?

1087

What is the use of RDBMS?

994

Is sql different from sql server?

1071

What is the use of keyword with encryption. Create a store procedure with encryption?

955

What are the benefits and tasks of object explorer? : sql server management studio

1172

Do you know how to implement service broker?

927

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