Hello all.
I am trying to use if not exists on a db update but am getting 'Invalid parameter binding(s).' errors.
Any ideas?
IF NOT EXISTS
(select mobile_number
FROM tblCustomer
WHERE mobile_number = 'nParam'
AND op_id = 'opParam'
)
BEGIN
INSERT INTO tblCustomer (
mobile_number, op_id
) VALUES (
'nParam',
'opParam'
)
END
Many thanks