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 5759

whats new about truncate in sql server 2008?

Serco, MedSave Healthcare,

1255

ow to bring suspect mode datbase online from scratch

644




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?

737

wat new abt truncate in sql server

HP, HCL,

2 3774

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

Microsoft,

733

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

Microsoft,

793

which backup strategy you are following at ur company

938




your distribution database is full what will u do

907

Differences between logshipping and mirroring

Syntel, Microsoft,

1 3198

tell me the disaster recovery plan

Microsoft,

1237

application server is slow what may be the problem

Microsoft,

1048

Define the term DML, DDL and DTL?

1 20937

Creating Tables Using SELECT

1 1607

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

3 2764


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

What is the difference between online clustering and Offline clustering?

1175


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

768


where the connection string store in the database

757


What are the dis_advantages of stored procedures, triggers, indexes?

903


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

318






Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

876


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

889


What is RMS migrations?

902


whats the maximum size of view state??

892


What is the difference between NOROW and LOCKROW?

1202


1 01 101 01010

689


your distribution database is full what will u do

907


role of sql sever 2005 in database rather than any other database

834


what exactly sql injuction.how to overcome.....

1262


Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

669