/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 vote163 views1 answer
Online doctor appointments in pakistan
TypeScript
1 vote151 views1 answer
Header imitate python
TypeScript
0 vote155 views1 answer
Render html contents from url in asp.net razor
TypeScript
0 vote134 views1 answer
Error: running homebrew as root is extremely dangerous and no longer supported. as homebrew does not drop privileges on installation you would be giving all build scripts full access to your system.
TypeScript
0 vote147 views1 answer
Do you use data structures in your current automation project
TypeScript
2 votes135 views1 answer
Create model class angular
TypeScript
0 vote155 views1 answer
Site:community.nxp.com dts gpio output high active
TypeScript
0 vote134 views2 answers
Get key of enum typescript
TypeScript
0 vote139 views1 answer
Components of cucumber bdd framework
TypeScript
1 vote136 views1 answer
Google sheets concatenate
TypeScript