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?

1119

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

1077

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

1067

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

1220

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

1121

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

1190

How to define output parameters in stored procedures?

1088

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

1099

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

1066

How to configure and test odbc dsn settings?

1228

How to list all user names in a database?

1097

How to create a user name in a database?

1105

What are indexes in ms sql server?

1120

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

1346

What are the mathematical functions supported by sql server 2005?

1132

Un-Answered Questions { SQL Server }

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1900

What is ddl command?

1035

What is set nocount on?

997

A trigger can reference objects outside the current database? State true or false.

1062

How to view the error log for any specific instance? : sql server database administration

1098

What is difference between unique and primary key?

972

‘Order by’ is not allowed in a view how can you sort information from a view?

1126

List out the difference between union and union all in sql server?

1043

What command do we use to rename a db, a table and a column?

984

What are information schema views?

1035

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

948

How to store and query spatial data?

1049

Explain the working of sql privileges?

1146

Explain about local stored procedure?

1031

What are a scheduled jobs?

998

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