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

Can anyone explain difference between Database, Data warehouse and Data mart with some example?````

4 6876

how to get max salary with employee number by using one select query and max function ??

Genpact,

3 8702

What are the difference between data length and length in SQL Server-2008?

Scio Healthcare,

3 6343

Why foreign key column allowing null values even a parent tables reference key column not having null value..

IBM,

2 6219

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 4923

Write a query to get all details of employee who has maximum salary from employee table

AON, Genpact,

8 16724

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

Broadridge,

6 12217

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

HCL,

2399

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

Cognizant, HCL, Value Labs,

1 8140

how many non clustered index in sql server 2008,2010,2012

Accenture,

2 7168

what is the difference between table and view

1 3299

plss anybody specify tha constrian management system in dbms

Police Constable,

2150

How to genrate automaticlly empid like gt001

4 5721

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

Apple,

3 6792

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

IBM, L&T,

3 7075

Un-Answered Questions { SQL Server }

What is the full form of dql?

981

What is the use of =,==,=== operators?

1013

What are the joins in sql server? : sql server database administration

1003

What is the difference between createstatement and preparedstatement?

940

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1062

Please explain go command in sql server?

1051

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1158

Can I delete event logs?

924

What is table-valued sub query?

967

How do you send email on SQL Server?

1064

What is the importance of concurrency control?

1227

How to delete duplicate records based on single column from a table?

1048

How can you insert null values in a column while inserting the data?

1280

What is the maximum number of index per table?

1073

Why do we use trigger?

971

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