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?

971

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 }

What is a collation in ms sql server?

1083

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

1014

What are different types of database indexes?

1100

What is a bit datatype?

987

What is sql server agent and what are the two modes of authentication in sql server?

1056

Can sql servers linked to other servers like oracle?

953

What new data source types were added in ssrs 2014?

160

Explain the difference between primary keys and foreign keys?

1023

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1147

How to delete duplicate rows in sql server?

1106

How does the report manager work in SSRS?

149

Why is sql server log file full?

1034

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2362

How to create a user name in a database?

1054

What stored procedure can you use to display the current processes?

893

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