Answers for "sql if exists update column value"

Check if value exisits update or insert sQL

IF EXISTS (SELECT * FROM Bookings WHERE FLightID = @Id)
BEGIN
    --UPDATE HERE
END
ELSE
BEGIN
   -- INSERT HERE
END

Posted by: Guest on January-18-2021

sql value exists in column

SELECT * FROM table_name WHERE col_name = my_value;
SELECT * FROM table_name WHERE col_name LIKE '%my_value%';

Posted by: Guest on July-08-2021

Code answers related to "sql if exists update column value"