判断插入的数据在表中存不存在
存在就更新,不存在就插入
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