/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 vote283 views3 answers
How to print brackets characters in c#
TypeScript
1 vote236 views1 answer
Replace all br tags within node with paragraph opening and closing tags
TypeScript
1 vote197 views1 answer
Ionic pasword visible inside ion-input
TypeScript
0 vote214 views1 answer
Typescript named return
TypeScript
0 vote239 views1 answer
Ts enum string' can't be used to index type
TypeScript
6 votes235 views1 answer
An unhandled exception occurred: Cannot find module '@angular-devkit/build-angular/package.json'
TypeScript
1 vote216 views1 answer
How to pass children in react typescript
TypeScript
1 vote237 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
18 votes225 views6 answers
Remove multiple elements from array es6
TypeScript
0 vote249 views1 answer
My bootstrap alerts code is not closing
TypeScript