Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...



SQL Server Interview Questions
Questions Answers Views Company eMail

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 15062

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 2645

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

Deloitte, Lason,

9 21187

A left outer join B B right outer join A gives the same result then what is the use of two?

1 3969

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

Sparsh,

2 6561

event classes in sql server

Accenture, AFE,

2 5310

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

CarrizalSoft Technologies, L&T,

4 8255

what is macro?

Excel, Global Innovation, Wipro,

5 9252

After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

Cognizant,

1207

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

Sapient,

2 3656

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 10563

What is Files and Filegroups in SQL Server & it's implementation.

Zenith,

1 7308

What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query

Apollo,

2 4300

what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?

2 13516

Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key

1 9256







Un-Answered Questions { SQL Server }

How to execute stored procedure and set temp table in sql server?

145


What does the automatic recovery do?

139


How can delete duplicate records in cte in sql server?

105


What is meant by dirty read?

92


how to overcome kernel isssues

750






How will you know when statistics on a table are obsolete?

154


How many types of schemas are there?

108


What are trace flags and mention a few common trace flags used with sql server?

141


What are some examples of schemas?

109


Can select statements be used on views in ms sql server?

156


What is the Main Difference between ACCESS and SQL SERVER?

184


How do you identify a foreign key?

109


What are the advantages of using stored procedures in sql server?

131


How many types of keys are there?

101


Explain the stored procedure?

150