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 7047

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

2 4967

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

Ramco,

5 10417

difference between truncate, delete aur drop?

2 5256

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

ABC,

1 5563

how can u get last observation in an unknown dataset ?

Genpact,

2436

What is stored procedure in SQL..??

2 4903

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 4110

whats the maximum size of view state??

2193

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

Cap Gemini,

1 5690

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

Cap Gemini,

6 9050

What is Schema in Database?

Cap Gemini,

1 5529

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

Cap Gemini,

1 5069

What is index?

Cap Gemini,

1 4614

Tell me about Triggers?

Cap Gemini,

3 7236

Un-Answered Questions { SQL Server }

What protocol does sql server use?

944

How to install sql server 2005 express edition?

1122

Name and describe few console utilities for ssrs?

284

If user is owning any SQL Objects, can we drop that user

2076

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

956

What are different types of data sources?

1019

How to change parameter value inside the report?

164

What is ddl command?

975

query processing

2173

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

982

Difference between drill down and drill through report.

956

Explain the difference between HTTP and HTTPS in database?

1036

How many types of the database links?

1070

What is the use of sign function?

1124

What is snapshot report?

165

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