Pro-Test available
CREATE PROCEDURE [dbo]. [Insertmessage] (@strTable varchar ( -), --table name @strvalues nvarchar ( +), --the data to be inserted (separated by commas), if it is a string type, enclose the single quotation mark @only_field varchar ( -) =null,--uniqueness Field (column name) @only_value varchar ( -) =null,--Uniqueness field value @msg nvarchar ( -) =null--error message) asBEGIN SET NOCOUNT on;declare @sqlString varchar ( the); IF @only_field isNotNULLBEGIN DECLARE @pint; --Query Uniqueness Results declare @sql nvarchar ( +); --splicing Query SQL stringSet@sql ='SELECT @p=count (1) from'[Email protected]+'WHERE'[Email protected]_field+'='+@only_value; EXEC sp_executesql @sql, N'@p as int OUTPUT', @p OUTPUTif@p >0begin RAISERROR (@msg, -,1) returnEndElsebeginSet@sqlString ='Insert into'[Email protected]+'VALUES ('[Email protected]+')'; EXEC (@sqlString); End Endelse beginSet@sqlString ='Insert into'[Email protected]+'VALUES ('[Email protected]+')'; EXEC (@sqlString); EndEnd--execute [dbo]. [Insertmessage]'Base._member',"0,2,getdate (), 0,1, ' 4445 ', ' 654321 ', ' 654321 ', N ' Sinco '",'ACCTNBR','4445'N'the membership card number already exists and cannot be added again!'--execute [dbo]. [Insertmessage]'Base._member',"0,2,getdate (), 0,1, ' 4445 ', ' 654321 ', ' 654321 ', N ' Sinco '", Null,null,null
SQL Server stored procedures increased