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 to retrieve error messages using mssql_get_last_message()?

1040

What are user defined functions in ms sql server?

989

Can binary strings be converted into numeric or float data types?

1022

Can you use order by when defining a view?

968

What are commonly used odbc functions in php?

1011

What are views in ms sql server?

1071

How to enter unicode character string literals in ms sql server?

1063

How to create database with physical files specified in ms sql server?

990

How to create an index on an existing table in ms sql server?

975

What are the requirements on sql server network connections?

967

How to verify the port number of the sql server?

1139

What are date and time data types in ms sql server?

1084

How to execute a sql statement using odbc_exec()?

1130

What is a database table?

963

How to create a stored procedure with a statement block in ms sql server?

1063

Un-Answered Questions { SQL Server }

What is analysis service repository?

1020

What is the difference between a check constraint and a rule?

1233

Can we call stored procedure in view in sql server?

891

How to apply filtering criteria at group level with the having clause in ms sql server?

993

Tell me what are the advantages of using stored procedures?

1000

What are the disadvantages of using querystrings to send data from one page to another?

998

difference between Clustered index and non clustered index ?

987

define and explain the differences between clustered and non-clustered indexes.

1188

What are the types of stored procedures in an sql server?

981

What is plan freezing?

960

What are xml indexes?

941

What happens on checkpoint?

1020

What are orphan records?

926

what are acid properties? : Sql server database administration

988

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

956

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