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

how can i lock the column in the table

Accenture,

2 7045

what is the basic diffrence betn a col declared in char(1) and in varchar(1)

2 4965

how to get the salary in descending order with out using the keyword desc in sql

Ramco,

5 10415

difference between truncate, delete aur drop?

2 5255

how many no of arguments can be passed in procedures and functions

ABC,

1 5562

how can u get last observation in an unknown dataset ?

Genpact,

2436

What is stored procedure in SQL..??

2 4902

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 4108

whats the maximum size of view state??

2192

How can u get the number of pupils connecting the database?

Cap Gemini,

1 5689

How to a Query to copy data from on table to another table.

Cap Gemini,

6 9049

What is Schema in Database?

Cap Gemini,

1 5528

What is storeprocedure?Tell me synatx for how to write stored procedure.

Cap Gemini,

1 5063

What is index?

Cap Gemini,

1 4613

Tell me about Triggers?

Cap Gemini,

3 7232

Un-Answered Questions { SQL Server }

What is attribute relationships, why we need it? : sql server analysis services, ssas

967

Explain the use of keyword with encryption. Create a store procedure with encryption?

961

Give an example of why you would want to denormalize a database

976

What are recommended options to be used while using db mirroring? : sql server database administration

1155

Differentiate between ms sql server reporting services vs crystal reports?

904

What are the general features of sql server management studio? : sql server management studio

1076

How to turn off warning messages during php execution?

1044

How to handle error or exception in sql?

982

What are the differences between triggers and stored procedures?

1069

explain different types of joins? : Sql server database administration

985

Can we take the full database backup in log shipping?

953

Define a cross join?

1015

what is the maximum size of a row? : Sql server database administration

1014

What encryption security is available in sql azure?

101

What is dbcc command in sql server?

1091

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