存在就更新,不存在就插入 登录后复制 1 IF NOT EXISTS ( 2 SELECT 3 cInvCCode 4 FROM 5 [{0}].[dbo].InvDefaultValue 6 WHERE 7 cInvCCode = @cInvCCode 8 ) 9 INSERT 10 INTO [{0}].[dbo].InvDefaultValue( 11 cInvCCode 12 , cInvCName 13 , cFld 14 ) 15 VALUES ( 16 @cInvCCode 17 , @cInvCName 18 , @cFld 19 ) 20 ELSE 21 Update [{0}].[dbo].InvDefaultValue 22 Set 23 cInvCCode = @cInvCCode 24 , cInvCName = @cInvCName 25 , cFld = @cFld 26 from 27 [{0}].[dbo].InvDefaultValue 28 where 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28. 作者:꧁执笔小白꧂ 原创作者: u_16822845 转载于: https://blog.51cto.com/u_16822845/11676118