write down the sql query?
Table Name : emp1
empid empname
1 bala
2 guna
Table Name : emp2
empid empname
1 <Null>
2 <Null>
Solution : emp1 names are updated in emp2, write a query?
Answer Posted / a
Update emp2 set empname = (Select empName from emp1 where
emp2.empid =emp1.empid)
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are the different types of replication are there in sql server 2000?
how to control the amount of free space in your index pages? : Sql server database administration
Do you know what is user defined datatypes and when you should go for them?
How do I start sql server agent automatically?
What does the update command do?
Explain the different index configurations a table can have?
What is raid, and how it can influence database performance?
Explain how you can deploy an SSRS report?
What is filtered index?
What is transaction server auto commit?
What is an expensive query?
How many categories of functions based their return modes?
What is the command used to check locks in microsoft sql server?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
How to delete a database in ms sql server?