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 78991)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
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?