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 5759
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?737
how to use DTS package in 2000,2005,2008 in sql server733
on line cluster can we make if yes tell me the procedure793
tell me the disaster recovery plan1237
application server is slow what may be the problem1048
Define the term DML, DDL and DTL?1 20937
Creating Tables Using SELECT1 1607
How can I create a table from another table without copying any values from the old table?3 2764
What is the difference between online clustering and Offline clustering?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
where the connection string store in the database
What are the dis_advantages of stored procedures, triggers, indexes?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
What is RMS migrations?
whats the maximum size of view state??
What is the difference between NOROW and LOCKROW?
1 01 101 01010
your distribution database is full what will u do
role of sql sever 2005 in database rather than any other database
what exactly sql injuction.how to overcome.....
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)