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 fixed length strings are truncated and padded?

972

How to create a testing table with test data in ms sql server?

1076

How to delete a database in ms sql server?

1219

Can you roll back the ddl statement in a trigger?

958

What are character string data types in ms sql server?

1234

How to modify existing triggers using "alter trigger"?

1009

How to delete an existing row with delete statements in ms sql server?

1083

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

975

How to run sql server 2005 books online on your local system?

955

Can you pass expressions to function parameters?

1096

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

999

How to convert numeric values to integers in ms sql server?

1083

What are the advantages of passing name-value pairs as parameters?

1160

How to create a local temporary stored procedure?

997

What happens if null values are involved in datetime operations?

967

Un-Answered Questions { SQL Server }

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1598

What are drilldown reports?

152

How to list all user names in a database?

1047

How to create an identity column?

1201

Can you explain what is sql server english query?

992

How to create an inline table-valued function?

961

What is blocking?

1051

How many types of triggers are there?

1057

What is the osql utility?

950

What it means to be triggered?

987

what does the automatic recovery do? : Sql server administration

1014

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

2003

Explain alternate key, candidate key and composite key in sql server?

905

What is the difference between dropping a database and taking a database offline?

1165

How to configure and test odbc dsn settings?

1151

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