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 88681)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?
1570
What are the types of database schema? : sql server analysis services, ssas
if no size is defined while creating the database, what size will the database have? : Sql server administration
What is the difference between count () and rowcount ()?
What does it mean to be in union?
What do you understand by sql server agent?
What are the difference between clustered and a non-clustered index?
What is analysis service repository?
How do you troubleshoot errors in a SQL Server Agent Job?
Are all views updatable ?
How to define and use table alias names in ms sql server?
We need to perform what steps in the following order to work with a cursor?
Explain ms sql server reporting services vs crystal reports?
What is a covering index?
Does group by sort data?
If a table does not have a unique index, can a cursor be opened on it?