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?

1092

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()?

1039

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?

1124

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 }

What is difference between rollback immediate and with no_wait during alter database?

1090

Do I need a report server to run reports in my application?

165

What is data mart? : sql server analysis services, ssas

1055

List out the differences between global and local temp tables in sql server?

1060

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

979

What are the new features of sql server 2012 reporting service?

133

What is perspective, have you ever created perspective? : sql server analysis services, ssas

917

What are different types of table joins?

1008

what are the types of indexes? : Sql server database administration

1122

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

Explain what is lock escalation?

1064

Can you index views?

895

How to make a remote connection in a database?

977

What is temporal table?

887

What are trace flags?

1032

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