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 enter comments in transact-sql statements?

944

How to loop through result set objects using mssql_fetch_array()?

1076

How to use user defined functions in expressions?

1090

How to use group functions in the select clause in ms sql server?

1052

How to list all dsn entries on your local machine using odbc_data_source()?

1037

How to count rows with the count(*) function in ms sql server?

1014

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

1125

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

1123

How to change the name of a database user?

960

What is the security principal at the database level that represents your session?

942

How to loop through result set objects using odbc_fetch_row()?

976

What are triggers in ms sql server?

1160

How to disable triggers using "disable trigger"?

1056

Can the query output be sorted by multiple columns in ms sql server?

980

How many ways to create table-valued functions?

986

Un-Answered Questions { SQL Server }

How many types of functions are there in sql server?

946

What are functions in the sql server?

1217

What is meant by indexing files?

1040

What is the maximum size of column in sql server?

892

Tell me about builtinadministrator?

1001

What is named calculation? : sql server analysis services, ssas

980

What are subqueries in sql server?

1120

What is data modeling and Reterminal integrity?

1955

What is the name of the Database which IBM mainframe uses?

987

What is sql server replication? : sql server replication

984

How do I find the sql server version?

1025

Explain different types of Normalization.

1832

How to return the top 5 rows from a select query in ms sql server?

1136

What is set nocount on?

938

Difference between uniqe index and uniqe constraint?

979

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