update e2 set e2.empname = e1.empname from emp2 e2,emp1 e1 where e1.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 / dhana

8 Answers
12421 Views
I also Faced
E-Mail Answers

Answer Posted / dhana

update e2 set e2.empname = e1.empname
from emp2 e2,emp1 e1
where e1.empid = e2.empid

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Mention the 3 ways to get a count of the number of records in a table.

960

Define Unique Key?

983

Detail about the hardware which is supported by SQL server?

1045

How to backup encryption key ?

180

What is the size of transaction log file?

902

What is the use of set nocount on/off statement?

1074

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

982

What is rank function?

1012

How to how to convert numeric expression data types using the convert() function??

1029

Explain the first normal form(1nf)?

1004

What is compression - row-level and page-level compression?

894

What is query parameter in ssrs?

160

How to use copy and concatenate commands in SQL?

1119

How many types of cursor type are there?

1070

What to check if a User database is locked?

1049