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

Is Sql non procedural query language?

Verifone,

1 1550

Write a SQL command to insert and update only a particular field?

ADITI,

1105

How efficient you are in oracle and SQL server?

CGI,

1146

What are the steps to follow to configure SQL*Net?

Tech Mahindra,

1028

What do you understand by SQL*Net?

Tech Mahindra,

1018

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

IBM,

1135

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

IBM,

984

When to use Inner join & when to use subquery?

IBM,

1155

how many type of indexing in database?

IBM,

975

Difference between rowid and rownum in SQL?

Virtusa,

1 1848

How can you swap values between two rows in a table using single- SQL statement?

Tavant Technologies, Virtusa,

1 2690

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

Amazon,

918

what is the difference between Delete and Truncate command in SQL

BirlaSoft,

1144

What Is Rdbms?

Accenture,

1149

How can you tell if a database object is invalid?

MCN Solutions,

1072

Un-Answered Questions { SQL Server }

How many null values we can have in a unique key field in sql server?

952

Which is better statement or preparedstatement?

922

Why use stored procedures in sql server?

1007

What is the temp table?

912

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

2579

What are the differences between stored procedure and the dynamic sql?

1085

How to execute the cursor queries with "open" statements?

1175

What stored by the tempdb ? : sql server database administration

1040

What are the types of dml?

976

What do you mean by an execution plan? Why is it used? How would you view it?

924

How do you run a trace?

893

How to delete a login name in ms sql server?

1066

do views contain data ?

956

What is bookmark link in ssrs?

244

Define self join?

1023

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