SQL Server stored procedures increased

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