SELECT * FROM tbl_Students WHERE FirstName LIKE '%' + @FirstNameString + '% AND LastName LIKE '%' + @LastNameString + '% Anyway, I want the option for the user to specify one or both. So they can ...
I'd like to know that a NULL is going to be inserted into a non-nullable field on one row via RAISEERROR, skip that row's update, and then allow the SQL statement to continue.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results