/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 vote205 views1 answer
Running tests in r
TypeScript
0 vote199 views1 answer
Push and array of objects to firebase
TypeScript
0 vote228 views1 answer
Typescript default public or private
TypeScript
6 votes207 views2 answers
Experimental support for decorators is a feature that is subject to change in a future release. Set the 'experimentalDecorators' option in your 'tsconfig' or 'jsconfig' to remove this warning
TypeScript
16 votes185 views1 answer
Python loop two
TypeScript
0 vote208 views1 answer
Local Variable in Jenkins
TypeScript
0 vote177 views1 answer
NFS is reporting that your exports file is invalid. Vagrant does this check before making any changes to the file. Please correct the issues below and execute "vagrant reload":
TypeScript
1 vote207 views1 answer
Is assigned a value but never used
TypeScript
2 votes230 views1 answer
Three dots icon flutter
TypeScript
0 vote359 views1 answer
Factory design pattern typescript
TypeScript