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.6 7899
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?1370
how to use DTS package in 2000,2005,2008 in sql server1324
on line cluster can we make if yes tell me the procedure1372
tell me the disaster recovery plan1876
application server is slow what may be the problem1626
Define the term DML, DDL and DTL?1 28184
Creating Tables Using SELECT1 2408
How can I create a table from another table without copying any values from the old table?3 4260
Can we update data in a view?
How many types of schemas are there?
How can we delete Duplicate row in table?
What are the advantages of paper records?
How do I manually uninstall an instance of sql server 2016?
What is indexing a document?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How can we solve concurrency problems?
What is exclusive locks?
What is an example of a foreign key?
Explain isolation levels that sql server supports?
do views contain data ?
Explain transaction server consistency?
What are the advantages of policy management?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?