Click here to Skip to main content
15,901,122 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
SQL
SELECT * FROM Tbl_Emp_Mst E
JOIN Tbl_User_Info U ON U.C_Code=E.C_EmpCode
JOIN Tbl_UserRights US ON US.c_userid=E.C_EmpCode
JOIN Tbl_FS_Mst FS ON FS.C_EmpNo=FS.C_EmpNo
JOIN tbl_fs_emp_rel FSM ON FSM.c_emp_code=E.C_EmpCode
JOIN FSHEIRARCHY FSH ON FSH.empcode=E.C_EmpCode

In this all 6 table having one unique column..I want to update that column for all 6 tables at a time..can it possible to do that.

Please tell me since it is very urgent for me.
Posted
Updated 17-Mar-15 19:02pm
v2
Comments
barneyman 18-Mar-15 1:46am    
you want to change *existing* ids - say the ID now for an employee is 'id001' you want to make that 'newidAAA1' ?

1 solution

Hi,

You can use Triggers -- SQL Server[^]

Check it.

Hope this will help you.

Cheers
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900