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 6784
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?1089
how to use DTS package in 2000,2005,2008 in sql server1083
on line cluster can we make if yes tell me the procedure1109
tell me the disaster recovery plan1583
application server is slow what may be the problem1357
Define the term DML, DDL and DTL?1 25268
Creating Tables Using SELECT1 2020
How can I create a table from another table without copying any values from the old table?3 3627
What is the command used to check locks in microsoft sql server?
Can primary key be null?
What is user-defined functions? What are the types of user-defined functions that can be created?
How can we solve concurrency problems?
Distinguish between nested subquery and correlated subquery?
How global temporary tables are represented and its scope?
Explain some stored procedure creating best practices or guidelines?
How to delete existing triggers using "drop trigger"?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
Comment,Datatypes are unlimited
can SSRS reports Cache results?
How to create a view with data from multiple tables?
Write query to return all rows sql?
What are the different types of subquery?
Define Wed Edition in SQL Azure?