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 86531)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?
1520
What are the different Topologies in which Replication can be configured?
How can we delete a table in sql server?
What is the use of group by clause?
What are different types of subquery?
What do you mean by sql server 2005 express management tools?
What is the difference between deallocate cursor and close cursor?
What is difference between rownum and row_number?
Explain about extended stored procedure?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How we can refresh the view?
Explain what is use of dbcc commands?
What is a linked server in sql server?
Explain boyce and codd normal form(bcnf)?
Explain the properties of a relational table?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration