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

What is an identity column in insert statements?

1022

Where are sql server user names and passwords stored in sql server?

1090

What is the difference between substr and charindex in the sql server?

1101

What is the difference between getdate and sysdatetime?

1005

What is the use of for clause?

1118

What are scheduled tasks in sql server?

1083

What is bulkcopy in sql?

943

Which command is used for user defined error messages?

1060

What is the use of sign function?

1124

What is the difference between varchar and nvarchar types?

1 1578

What will be query used to get the list of triggers in a database?

1002

What are the two authentication modes in sql server?

1117

Can we check locks in database? If so, how can we do this lock check?

942

What is sub query and its properties?

974

What is the use of @@spid?

1001

Un-Answered Questions { SQL Server }

what are candidate key, alternate key and composite key? : Sql server database administration

917

What are the mathematical functions supported by sql server 2005?

1070

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

935

What is 'Join' and explain its various types.

1136

How to provide column names in insert statements in ms sql server?

1155

Tell me in brief how sql server enhances scalability of the database system?

990

How does stuff differ from the replace function?

1010

What is the size of transaction log file?

931

what is a transaction and what are acid properties? : Sql server database administration

1024

Is sql server free?

916

How do you know if sql server is running on your local system?

1041

What are the advantages of stored procedure in sql server?

892

What are the advantages of partitioning?

1125

Define ACID properties in a Database?

1057

How to provide values to stored procedure parameters in ms sql server?

1037

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