sql updation

thanks sir

0

Hi,

you can write update query and replace the value
for example I have DepartmentMasters table and I want to replace row 1 (DepartmentId = 16) to row 2 (DepartmentId = 1) than query become

update DepartmentMasters
set Code = A.Code
FROM
(select * from DepartmentMasters where DepartmentId = 1) A
WHERE DepartmentMasters.DepartmentId = 16

hope this will help you.

0

Vulpes12y ago

There isn't a command which directly replaces a row.

You have to do it instead in either of the ways I gave in my opening post.

If there are only a handful of columns an update is usually easier and you need to include a where clause to identify the row to be replaced.

0

Mohit Pandey12y ago

Vulpes sir if i want replace one row to another row like row 1 to row 2 ....can it possible????

0

Vulpes12y ago

You can either update all the columns of the row individually or you can delete the row and insert a new row in its place.

0