SQL Server Interview Questions
Questions Answers Views Company eMail

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

Tech Mahindra,

6 8757

whats new about truncate in sql server 2008?

MedSave Healthcare, Serco,

2032

ow to bring suspect mode datbase online from scratch

1413

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

1544

wat new abt truncate in sql server

HCL, HP,

2 5588

how to use DTS package in 2000,2005,2008 in sql server

Microsoft,

1459

on line cluster can we make if yes tell me the procedure

Microsoft,

1517

which backup strategy you are following at ur company

1737

your distribution database is full what will u do

1683

Differences between logshipping and mirroring

Microsoft, Syntel,

1 4530

tell me the disaster recovery plan

Microsoft,

2032

application server is slow what may be the problem

Microsoft,

1786

Define the term DML, DDL and DTL?

1 30159

Creating Tables Using SELECT

1 2643

How can I create a table from another table without copying any values from the old table?

3 4630


Un-Answered Questions { SQL Server }

What is difference statement and preparedstatement?

552


What are the features of Embedded SQL

681


What is @@error in sql?

628


What are the extra roles available in msdb? : sql server security

646


Does index slows down insert statements?

588






What is filestream?

564


When we should use @@error?

546


How to transfer an existing table from one schema to another schema in ms sql server?

517


What is the difference between SQL notification and SQL invalidation?

598


What method is used by the Command classes to execute SQL statements that return single values?

612


Can you explain various data region available in ssrs with their use?

555


Can we deploy SSRS reports on our personal website?

123


Can you explain what are commit and rollback in sql?

491


How to list all login names on the ms sql server?

540


How to connect php with different port numbers?

563