/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

7 votes384 views1 answer
See what ports are in use
TypeScript
-2 votes317 views1 answer
Typescript operate with html objects
TypeScript
1 vote333 views4 answers
Pokediggerprank244
TypeScript
1 vote319 views2 answers
Measurement technique of total fiber attenuation gives
TypeScript
-1 vote274 views1 answer
Angular events list
TypeScript
0 vote330 views2 answers
When should you stop testing
TypeScript
0 vote355 views1 answer
Return tru if one of the objects in a aray has a fild match
TypeScript
0 vote378 views1 answer
Jest not toBe
TypeScript
2 votes325 views2 answers
Material form
TypeScript
-2 votes324 views1 answer
C++ get digits of integer
TypeScript