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?

1202

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?

1028

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?

981

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

1118

How to create a trigger for insert only?

1038

How to delete a login name in ms sql server?

1073

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

1242

Un-Answered Questions { SQL Server }

Which sql server is best?

992

What is collation sensitivity? Explain different types.

1010

How to fetch the next row from a cursor with a "fetch" statement?

1073

What are the advantages of log shipping?

995

How to specify the collation for a character data type in ms sql server?

1030

How do I connect to sql server database?

1010

How to provide login information for a new odbc dsn?

1052

What is the syntax for encrypting a column in SQL Server?

1120

How can delete duplicate records in cte in sql server?

964

Explain iaas, paas and saas?

Explain various On-Delete options in a DB table. Which is the default option?

1466

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

1002

Why use “nolock” in sql server?

1058

What happens if the update subquery returns no rows in ms sql server?

1123

How to enter date and time literals in ms sql server?

1016

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