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 107931)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?
2167
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
Which rendering formats are affected by the pagesize properties?
What are translations and its use? : sql server analysis services, ssas
What are approximate numeric data types in ms sql server?
List types of tables in SQL Azure?
How to create a large table with random data for index testing in ms sql server?
How to find Duplicate Records In table?
What is forward - only cursors / read only cursor?
What are sql dirty pages?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What is a database in ms sql server?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What are triggers? How do you invoke a trigger on demand?
What is an execution plan? When would you use it?
What is trigger explain with program?