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()?

1097

What are user defined functions in ms sql server?

1061

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

1091

Can you use order by when defining a view?

1019

What are commonly used odbc functions in php?

1056

What are views in ms sql server?

1118

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

1113

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

1033

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

1024

What are the requirements on sql server network connections?

1038

How to verify the port number of the sql server?

1246

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

1158

How to execute a sql statement using odbc_exec()?

1213

What is a database table?

1021

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

1123

Un-Answered Questions { SQL Server }

What is updatable resultset?

1070

What are the types of subquery?

1093

What is a data collection table?

1048

What is set nocount on and what is set nocount off?

993

Do you know what are acid properties?

1119

What is the difference between NOROW and LOCKROW?

2899

How to create an inline table-valued function?

1019

What is the difference between DATETIME2 and DATETIME?

1124

What are the export options of ssrs?

178

What is report snapshot in ssrs?

280

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

2451

What is recompile sql server?

1079

what are triggers? : Sql server database administration

949

How to round a numeric value to a specific precision?

1123

what is hash nonclustered index

1019

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