a guest Aug 20th, 2018 55 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- SELECT EXISTS (SELECT 1 FROM MyTable WHERE FirstName = @FirstName AND LastName = @LastName AND Address = @Address)
- SET @IsNewRecord = 1
- IF @IsNewRecord = 1
- INSERT MyTable
- VALUES (@FirtName, @LastName, @Addres, @City, @Phone)
RAW Paste Data