/TypeScript/Check if value exisits update or insert sQL

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

Source: stackoverflow.com

T-sql check if data exists

if exists(select 1 from INFORMATION_SCHEMA.TABLES T 
              where T.TABLE_NAME = 'Bookings') 
begin
    drop table Bookings
end
GO

create table Bookings(
  FlightID    int identity(1, 1) primary key,
  TicketsMax    int not null,
  TicketsBooked int not null
)
GO

insert  Bookings(TicketsMax, TicketsBooked) select 1, 0
insert  Bookings(TicketsMax, TicketsBooked) select 2, 2
insert  Bookings(TicketsMax, TicketsBooked) select 3, 1
GO

select * from Bookings

Source: stackoverflow.com

Similar codes

0 vote322 views1 answer
ReturnType FunctionName(FormalParameterList) { Statements ; return ReturnValue; }
TypeScript
-6 votes299 views4 answers
Could not find a declaration file for module react native type script
TypeScript
0 vote295 views1 answer
Testing tools vs testing techniques
TypeScript
0 vote298 views1 answer
Vulnerability of systems is divided into two (2) categories. List the two (2) categories.
TypeScript
0 vote327 views1 answer
How to exclude certain proprty from a class typescript
TypeScript
11 votes292 views6 answers
Localstorage
TypeScript
-1 vote323 views1 answer
Importhtml google sheets multiple tables
TypeScript
1 vote327 views1 answer
Styled components reset
TypeScript
0 vote322 views4 answers
Ngtemplateoutlet
TypeScript
2 votes298 views1 answer
Mat-option change event
TypeScript