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 do you know if sql server is running on your local system?

1041

How to get a list of columns in a view using the "sp_columns" stored procedure?

1040

How to use values from other tables in update statements in ms sql server?

1117

How to count duplicated values in a column in ms sql server?

1092

How to write a query with a left outer join in ms sql server?

983

What to perform pattern match with the like operator?

883

How to list all field names in the result set using mssql_field_name()?

914

What happens if null values are involved in comparison operations?

970

What is transact-sql language?

1094

How to grant a permission in ms sql server using "grant execute" statements?

1092

How to create a scrollable cursor with the scroll option?

999

How to create an multi-statement table-valued function?

994

What is a transact-sql statement batch in ms sql server?

1015

How to round a numeric value to a specific precision?

1074

What is the security model used in sql server 2005?

1009

Un-Answered Questions { SQL Server }

Explain what is “asynchronous” communication in sql server service broker?

917

What is the difference between varchar and nvarchar?

941

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1066

Is sql server a database?

994

What are the kinds of subquery?

1008

How to count duplicated values in a column in ms sql server?

1092

How many tables can be joined in SQL Server?

1064

What is the maximum size of a row in sql server?

967

Explain how does the report manager work in ssrs?

955

How you can get a list of all the table constraints in a database?

956

Explain trigger and trigger types?

980

How many categories of data types used by sql server?

1019

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1101

Explain user defined functions?

993

How to get a list all databases on the sql server?

1100

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