关联表--更新-删除数据

--源数据
SELECT　FID,FAccount,FLogonPass,FCompanyID,FTotalGeneration,FParentID,
　　　　 '123456789' AS Remark
INTO #tempTaccount
FROM dbo. TAccounts


SELECT * FROM #tempTaccount

 

 

 

 批量更新

--1
UPDATE #tempTaccount SET Remark='in'
WHERE FID IN (SELECT FID FROM dbo.TAccounts)


SELECT * FROM #tempTaccount

 

 

--2
UPDATE t1 SET Remark='INNER'
FROM #tempTaccount t1
INNER JOIN dbo.TAccounts AS b ON b.FID=t1.FID


SELECT * FROM  #tempTaccount

 

 

 

 批量删除

--1
DELETE FROM #tempTaccount
WHERE FID IN (SELECT FID FROM dbo.TAccounts WHERE FParentID=36052)

SELECT * FROM  #tempTaccount

--2
DELETE t1
FROM #tempTaccount t1
INNER JOIN dbo.TAccounts AS b ON b.FID=t1.FID AND b.FParentID=36052

SELECT * FROM  #tempTaccount