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 7145

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

2 5052

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

Ramco,

5 10578

difference between truncate, delete aur drop?

2 5345

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

ABC,

1 5640

how can u get last observation in an unknown dataset ?

Genpact,

2485

What is stored procedure in SQL..??

2 5003

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 4201

whats the maximum size of view state??

2248

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

Cap Gemini,

1 5776

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

Cap Gemini,

6 9233

What is Schema in Database?

Cap Gemini,

1 5608

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

Cap Gemini,

1 5151

What is index?

Cap Gemini,

1 4689

Tell me about Triggers?

Cap Gemini,

3 7368

Un-Answered Questions { SQL Server }

What according to you is the difference between mysql and sql server performance?

1143

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

960

What is rs.exe utility?

164

how can u get last observation in an unknown dataset ?

2485

What is an index in sql?

1069

Can you explain what is the use of custom fields in report?

1099

What is use of @@ spid in sql server?

1271

What are the types of user defined functions in sql server?

1095

How to write a query with a left outer join in ms sql server?

1029

How to provide values to user defined function parameters?

1060

How can change procedure in sql server?

1127

What is #table in sql server?

1096

What are the difficulties faced in cube development? : sql server analysis services, ssas

1099

What is self contained sub query?

1120

what types of replication are supported in sql server? : Sql server database administration

1129

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