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

Can multiple columns be used in sql group by clause in ms sql server?

1055

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

1034

How to create new databases with "create database" statements?

1029

How to filter out duplications in the returning rows in ms sql server?

1143

How to list all user defined functions in the current database?

1051

How to list all login names on the ms sql server?

1147

How to define output parameters in stored procedures?

1030

How to how to convert numeric expression data types using the convert() function??

1057

What are group functions in query statements in ms sql server?

1013

How to configure and test odbc dsn settings?

1161

How to list all user names in a database?

1059

How to create a user name in a database?

1060

What are indexes in ms sql server?

1065

What are unicode character string data types in ms sql server?

1265

What are the mathematical functions supported by sql server 2005?

1074

Un-Answered Questions { SQL Server }

How to insert a new row into a table with "insert into" statements in ms sql server?

979

What are commonly used odbc functions in php?

1017

How do you delete duplicate records in sql server?

1067

What are the different types of Indexes available in SQL Server?

1010

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1010

What is SQL Azure Data sync?

121

what are different types of backups available in sql server? : Sql server database administration

942

Define tool Manage Statistics in SQL Server 2000 query ?

1099

Can you index views?

899

How do I view a procedure in sql server?

996

Does index slows down insert statements?

1003

What are partitioned views?

1003

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1083

What is the difference between local and global temporary tables?

1141

Tell me about pre-defined functions of sql?

1113

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