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?

1011

How to rename databases in ms sql server?

1203

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

1114

How to create a dml trigger using create trigger statements?

1033

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

1010

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

1010

How to connect ms access to sql servers through odbc?

1030

How to add an address record into adventureworkslt?

986

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

1005

How to create a new schema in a database?

1151

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

982

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

1118

How to create a trigger for insert only?

1040

How to delete a login name in ms sql server?

1074

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

1244

Un-Answered Questions { SQL Server }

How to generate create table script on an existing table in ms sql server?

1141

What is the difference between sdf and mdf?

1300

What is a recursive stored procedure in sql server?

1175

What is the standby server?

955

What is the difference between update lock and exclusive lock?

976

Explain the commands in sql server?

1038

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

1131

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

948

How to drop an existing stored procedure in ms sql server?

1032

What is reportserver and reportservertempdb ?

152

What is data file in computer?

947

Do you know the isolation level that sql server support?

960

What is the usage of the sign function?

1114

How to delete existing triggers using "drop trigger"?

1053

How many database files are there in sql server 2000?what are they?

1051

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