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?

936

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

1069

How to use user defined functions in expressions?

1082

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

1049

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

1032

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

1010

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

1121

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

1119

How to change the name of a database user?

956

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

932

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

970

What are triggers in ms sql server?

1157

How to disable triggers using "disable trigger"?

1051

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

976

How many ways to create table-valued functions?

978

Un-Answered Questions { SQL Server }

What is an example of a primary key?

979

What are the key configuration files for sql server reporting services ?

167

What is measure group, measure? : sql server analysis services, ssas

1001

What is a synonym for manipulation?

986

How to transfer an existing table from one schema to another schema in ms sql server?

977

What is the difference between varchar and nvarchar datatypes?

1080

What is the difference between truncate and delete commands?

1061

How do I create a trace in sql server?

1029

can an automatic recovery be initiated by a user? : Sql server administration

945

What is Cross Join and in which scenario do we use Cross Join?

1011

What is amo? : sql server analysis services, ssas

1086

What types of Joins are possible with Sql Server?

1116

How many databases can we create in a single server?

207

Why should one not prefix user stored procedures with ‘sp_’?

1036

What are various limitations of the views?

1049

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