/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

6 votes162 views1 answer
File C:\Users\SHUBHAM KUNWAR\AppData\Roaming\npm\nodemon.ps1 cannot be loaded because running scripts is disabled on this system. For more information, see about_Execution_Policies at https:/go.microsoft.com/fwlink/?LinkID=135170.
TypeScript
1 vote166 views1 answer
Whats my country
TypeScript
0 vote164 views1 answer
Object is possibly 'null'. 20 *ngIf="!signupForm.get('email').valid && signupForm.get('email')!.touched "
TypeScript
9 votes172 views1 answer
Print list without brackets int python
TypeScript
0 vote184 views1 answer
Inno add exe in service
TypeScript
1 vote216 views1 answer
Npm run serve https
TypeScript
0 vote189 views1 answer
Sort a list of ints python in descending order
TypeScript
0 vote173 views1 answer
Ts new example
TypeScript
0 vote178 views3 answers
How to bold to custom fonts on Online
TypeScript
-1 vote143 views2 answers
Jquery in angular
TypeScript