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?

1034

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

1036

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

1106

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

1075

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

968

What to perform pattern match with the like operator?

876

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

909

What happens if null values are involved in comparison operations?

961

What is transact-sql language?

1080

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

1080

How to create a scrollable cursor with the scroll option?

992

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

984

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

1010

How to round a numeric value to a specific precision?

1066

What is the security model used in sql server 2005?

996

Un-Answered Questions { SQL Server }

What is SQL Server?

1201

What are page splits? : SQL Server Architecture

981

What is the xml datatype?

1047

What is mscorsvw.exe - process - microsoft .net framework ngen?

944

What are Spatial data types in SQL Server 2008

1011

what are the important architecture components of SSRS?

140

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1027

Explain ranking functions?

1039

What is difference between views and stored procedures?

983

What is public role in sql server?

1141

What is a filestream?

985

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1050

Define primary key?

1127

Which tcl commands are available on the sql server?

1074

Can I disable or restrict ssrs export formats (rendering formats)?

150

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