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?

1018

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

1139

How to delete a database in ms sql server?

1315

Can you roll back the ddl statement in a trigger?

1018

What are character string data types in ms sql server?

1346

How to modify existing triggers using "alter trigger"?

1062

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

1145

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

1019

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

999

Can you pass expressions to function parameters?

1149

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

1048

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

1156

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

1215

How to create a local temporary stored procedure?

1043

What happens if null values are involved in datetime operations?

1021

Un-Answered Questions { SQL Server }

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

950

Write a sql query to sort on different column name according to the parameters passed in the function?

957

Can we add a cpu to sql server?

1059

Does the order of columns in update statements matter?

954

Define synonym?

1222

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

187

What is in place upgrade in sql server?

1090

What are the steps to insert a table?

989

Can we install sql server 2016 on windows 7?

1190

Which are the new data types introduced in sql server 2008?

925

How to use subqueries with the in operators in ms sql server?

1123

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1208

What are scheduled tasks in sql server?

1134

Explain the architecture of ms sql reporting service?

968

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1085

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