update emp2 set empname =e.empname from emp1 e where e.empid =emp2.empid

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?

Question Posted / vidya

8 Answers
12185 Views
I also Faced
E-Mail Answers

Answer Posted / vidya

update emp2 set empname =e.empname from emp1 e where
e.empid =emp2.empid

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the advantages of passing name-value pairs as parameters?

1107

How to count rows with the count(*) function in ms sql server?

952

How to use user defined functions in expressions?

1009

What is the maximum row of a size?

957

Why people hate cursor?

1097

What is dml command?

889

What is NOT NULL Constraint in sql server 2012?

937

What is efficiency data?

906

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

986

How to use "begin ... End" statement structures in ms sql server?

960

How many databases can we create in a single server?

205

What is a recursive stored procedure in sql server?

1088

What is transactional replication?

907

Define Wed Edition in SQL Azure?

100

What are the advantages of stored procedure in sql server?

834