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 create a new login name in ms sql server?

997

How to create a view with data from multiple tables?

969

How to retrieve field values using mssql_result()?

1192

How to convert a numeric expression from one data type to another?

934

How to join two tables in a single query in ms sql server?

943

How to count groups returned with the group by clause in ms sql server?

1008

How to access the deleted record of an event?

978

How to locate and take substrings with charindex() and substring() functions?

949

How to list all tables in the database using odbc_tables()?

983

What are approximate numeric data types in ms sql server?

1011

What are null values in ms sql server?

1025

How to set a database state to offline in ms sql server?

968

How to list all triggers in the database with sys.triggers in ms sql server?

1016

How to verify a user name with sqlcmd tool?

1023

How to use go command in "sqlcmd"?

1130

Un-Answered Questions { SQL Server }

What do you understand by the analysis services in sql server?

895

How to send email from database?

953

What is change data capture (cdc) feature?

1000

Explain primary key, foreign key and unique key?

936

What is GUID in sql server?

1094

Tell about MOM Tool(Microsoft Operator Manager)?

1854

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

926

What is the default fill factor value?

1013

How to receive output values from stored procedures?

1057

Explain Reporting Life Cycle?

111

What is a trace frag?

1036

How does clustered and non clustered index work?

851

What is snapshot parameter in ssrs?

140

Explain “@@rowcount” and “@@error” in sql server?

1007

1 01 101 01010

2004

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