/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 vote103 views1 answer
How many bits are there in a hexadecimal digit
TypeScript
0 vote109 views1 answer
Formula: =concatenate(transpose(xxxxx)) highlight transpose (xxxx), press "ctrl" + "=" then delete front and back curly brackets "{ }" enter Add grepper answer
TypeScript
0 vote115 views1 answer
Hack roblox account easy
TypeScript
2 votes103 views1 answer
Nodejs express multer s3
TypeScript
1 vote126 views1 answer
Execute only one test spec with angular-cli (ng test)
TypeScript
0 vote133 views1 answer
An unhandled exception occurred: Schematic "Module" not found in collection "@schematics/angular".
TypeScript
0 vote109 views2 answers
Benefits of matching in functional programming
TypeScript
1 vote109 views2 answers
The server time zone value 'FLE' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more
TypeScript
17 votes114 views3 answers
Typescript Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
TypeScript
3 votes114 views2 answers
Exists query elasticsearch 5.4
TypeScript