/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 vote150 views1 answer
Tailwind base components utilities
TypeScript
1 vote152 views1 answer
Ion2 calendar locale
TypeScript
15 votes156 views1 answer
Create react app with typescript config
TypeScript
0 vote132 views1 answer
Declaration of instance field not allowed after declaration of instance method. Instead, this should come at the beginning of the class/interface
TypeScript
5 votes135 views2 answers
Convert object object to array typescript
TypeScript
0 vote189 views1 answer
Typescript instantiate 2d array
TypeScript
0 vote136 views1 answer
How to delete a struct in a arra of strcts c
TypeScript
0 vote139 views2 answers
Moonspell (@moonspellofficial) • Instagram photos and videoswww.instagram.com › moonspellofficial 61.4k Followers, 619 Following, 2421 Posts - See Instagram photos and videos from Moonspell (@moonspellofficial)
TypeScript
0 vote131 views1 answer
Jasmine test button click
TypeScript
8 votes182 views6 answers
How to make lists in python
TypeScript