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

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

Aptroid,

1534

what is checksum in sql server.........???

TCS,

1636

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1464

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

United Healthcare,

1636

What is Lock table in SQL?

Wipro,

1414

Can we call a function that has out parameter in select statement

Nagarro,

1310

Call by value and call by reference in procedure and function, with NOCOPY.

Nagarro,

1251

If we delete pack Spec what will be the status of pack Body ?

Nagarro,

1438

Delete duplicate rows without using rowid.

Nagarro,

1501

how to find 6th highest salary

Chetak Logistics,

1485

Explain few examples of stored procedure over triggers?

ADITI,

971

What are the different types of backups that exist?

ADITI,

1115

What can be used instead of trigger?

ADITI,

1107

What does asynchronous call backs means?

Alcatel-Lucent,

1081

How do you implement session management in SQL Server mode?

Cap Gemini,

1031

Un-Answered Questions { SQL Server }

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1018

What is difference between count (*) and count 1?

871

What is the query and subquery?

1031

optimization techinques

2639

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

941

What happens if you insert a duplicate key for the primary key column in ms sql server?

940

How to check table values in sql server?

921

What is the difference between composite index and covering index?

906

How to replace given values with null using nullif()?

933

1 01 101 01010

2014

What is the difference between for auto and for nested?

943

How to insert data into an existing table?

925

Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.

1815

How many types of objects are there?

948

How do I view views in sql server?

947

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