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 extended stored procedures?

966

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1051

What security features are available for stored procedure?

1036

What is stored procedures?

1033

In what three ways is the return statement used in a stored procedure?

1008

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

929

Explain syntax for viewing, dropping and disabling triggers?

953

Explain triggers?

1005

How to apply cascading referential integrity in place of triggers?

1034

How to invoke a trigger on demand?

1092

What is ms sql server triggers?

1012

What are the instances when triggers are appropriate?

979

How many triggers you can have on a table?

993

Determine how to use the inserted and deleted pseudo tables?

991

Explain trigger classes i.e. Instead of and after trigger?

877

Un-Answered Questions { SQL Server }

How to test a dml trigger in ms sql server?

1042

How to convert a numeric expression from one data type to another?

1015

How can you insert null values in a column while inserting the data?

1280

Do you know what are the ways available in sql server to execute sql statements?

1028

What number aggregate functions are accessible there in sql?

1071

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

976

How can we improve performance by using SQL Server profiler?

1053

Difference between primary key and clustered index?

1005

When is the use of update_statistics command?

1005

Explain table valued parameters in sql server? Why tvp used?

1019

Explain the properties of sub-query in sql server?

1016

What is recompile sql server?

1036

What is the command dbcc checkdb used for?

1010

Explain error handling in ssis?

1023

What are various ways to enhance the ssrs report?

981

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