/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 vote131 views2 answers
Distance between two points latitude longitude c#
TypeScript
32 votes127 views1 answer
Policies for setting virtual environment -python
TypeScript
0 vote116 views2 answers
How to hack a roblox password
TypeScript
1 vote116 views1 answer
Get all documents in collection firestore flutter
TypeScript
0 vote193 views1 answer
INFO: This is taking longer than usual. You might need to provide the dependency resolver with stricter constraints to reduce runtime.
TypeScript
2 votes138 views1 answer
Numeric data type is returned as String
TypeScript
1 vote132 views1 answer
Serenity Criteria typescript
TypeScript
10 votes127 views2 answers
How to use variable as object key in typescript
TypeScript
3 votes118 views1 answer
Can't bind to 'formcontrol' since it isn't a known property of 'input'.
TypeScript
1 vote133 views1 answer
React-router-dom redirect on click
TypeScript