21 lines
1.4 KiB
SQL
21 lines
1.4 KiB
SQL
SELECT * FROM dbo.Sys_User WHERE Account='1814A'
|
|
|
|
SELECT * FROM dbo.HJGL_BS_Welder WHERE WED_Code='1814A'
|
|
|
|
SELECT * FROM dbo.Project_Welder WHERE WED_ID='d632d917-4cb3-420f-ac22-3d4f68fd7fbb'
|
|
|
|
SELECT * FROM dbo.Project_Welder WHERE WED_ID='ddc70778-4157-47c5-9d00-f2a15c5b6282'
|
|
|
|
SELECT * FROM dbo.HJGL_PW_JointInfo WHERE JOT_CellWelder='ddc70778-4157-47c5-9d00-f2a15c5b6282' OR JOT_FloorWelder='ddc70778-4157-47c5-9d00-f2a15c5b6282'
|
|
|
|
UPDATE dbo.HJGL_PW_JointInfo SET JOT_CellWelder='d632d917-4cb3-420f-ac22-3d4f68fd7fbb' WHERE JOT_CellWelder='ddc70778-4157-47c5-9d00-f2a15c5b6282'
|
|
|
|
UPDATE dbo.HJGL_PW_JointInfo SET JOT_FloorWelder='d632d917-4cb3-420f-ac22-3d4f68fd7fbb' WHERE JOT_FloorWelder='ddc70778-4157-47c5-9d00-f2a15c5b6282'
|
|
|
|
UPDATE dbo.Project_Welder SET WED_ID='d632d917-4cb3-420f-ac22-3d4f68fd7fbb' WHERE WED_ID='ddc70778-4157-47c5-9d00-f2a15c5b6282'
|
|
UPDATE dbo.HJGL_BO_Batch SET WED_ID='d632d917-4cb3-420f-ac22-3d4f68fd7fbb' WHERE WED_ID='ddc70778-4157-47c5-9d00-f2a15c5b6282'
|
|
UPDATE dbo.Sp_WelderOKRateStatistics SET WED_ID='d632d917-4cb3-420f-ac22-3d4f68fd7fbb' WHERE WED_ID='ddc70778-4157-47c5-9d00-f2a15c5b6282'
|
|
UPDATE dbo.Sp_WelderOKRate SET WED_ID='d632d917-4cb3-420f-ac22-3d4f68fd7fbb' WHERE WED_ID='ddc70778-4157-47c5-9d00-f2a15c5b6282'
|
|
|
|
DELETE FROM dbo.HJGL_BS_WelderQualifiedProject WHERE WED_ID='ddc70778-4157-47c5-9d00-f2a15c5b6282'
|
|
DELETE FROM dbo.HJGL_BS_Welder WHERE WED_ID='ddc70778-4157-47c5-9d00-f2a15c5b6282' |