Create Table  beehives_Bookings 
(
 BB_Id bigint identity(1,1),
 booking_id bigint,
 amount numeric(12,2),
 tax_amount numeric(12,2),
 first_name varchar(1000),
 last_name varchar(1000),
 phone varchar(500),
 email varchar(500),
 country varchar(100),
 state varchar(100),
 city varchar(100),
 zip varchar(100),
 address varchar(100),
 number_of_guests bigint,
 room_number  varchar(100),
 start_date datetime,
 end_date datetime,
 status varchar(500),
 updated_date datetime,
 actualinsertdate datetime,
)


 Create Procedure Exec_beehives_Bookings(@booking_id bigint,@amount numeric(12,2),@tax_amount numeric(12,2),@first_name varchar(1000),@last_name varchar(1000),@phone varchar(1000),@email varchar(500),@country varchar(500),@state varchar(500),
 @city varchar(500),@zip varchar(500),@address varchar(1000),@number_of_guests bigint,@room_number varchar(500),@start_date datetime, @end_date datetime,@status varchar(500),@updated_date datetime ,@actualinsertdate datetime)
 as
 
 	Insert into beehives_Bookings(booking_id,amount,tax_amount,first_name,last_name,phone,email,country,state,city,zip,address,number_of_guests,room_number,start_date,end_date,status,updated_date,actualinsertdate)
	Values(@booking_id,@amount,@tax_amount,@first_name,@last_name,@phone,@email,@country,@state,@city,@zip,@address,@number_of_guests,@room_number,@start_date,@end_date,@status,@updated_date,@actualinsertdate)
 SELECT SCOPE_IDENTITY() AS [BB_Id];