alter table SaleType
add hscode nvarchar(50),
productDescription nvarchar(50),
rate nvarchar(50),
uoM nvarchar(50),
quantity  integer,
totalValues  money,
valueSalesExcludingST money,
fixedNotifiedValueOrRetailPrice money,
salesTaxApplicable money,
salesTaxWithheldAtSource money,
extraTax nvarchar(50),
furtherTax integer,
sroScheduleNo nvarchar(50),
fedPayable money,
discount money,
sroItemSerialNo nvarchar(50)
=======================================
alter table Product
add Sale_Type nvarchar(100) null
==============================
alter table POS_Setting
alter column Scale_Code nvarchar(50)
===================================
alter table Temp_Stock
alter column Reorder int
===================================
alter table Product_rec
add Sale_Type nvarchar(100) null
===============================
alter table Temp_Stock
add Sale_Type nvarchar(100) null
======================================
alter table Temp_Bill
add Sale_Type nvarchar(100) null
==============================                pgs
alter table Product_rec
alter column BCode nvarchar(50)
==============================================
create table online_booking (
Code nvarchar(100) null,
Product nvarchar(200) null,
Qty int,
Price money,
cid nvarchar(50),
Client nvarchar(100) null,
Area nvarchar(50) null,
Booker nvarchar(50) null,
Book_Date datetime
)
=========================================
alter table Cash_trans
alter column Description nvarchar(200)
alter table Cash_trans
alter column Remarks nvarchar(200)
alter table online_booking
add total money
alter table commssion_salesman
alter column Product nvarchar(max) null
=======================================
alter table Sales_rec
add AdvH_Tax money
alter table Sales_rec
add AdvH_Tax_per Float (53)
alter table Sales_rec
add Fur_Tax money
alter table Sales_rec
add Fur_Tax_per Float (53)
==================================
alter table Temp_Bill
add AdvH_Tax money
alter table Temp_Bill
add AdvH_Tax_per Float (53)
alter table Temp_Bill
add Fur_Tax money
alter table Temp_Bill
add Fur_Tax_per Float (53)
==================================
alter table online_booking
add schm int null
================================
alter table Sales_Detail
add Data_Status nvarchar(50) null
alter table Sales_rec
add Data_Status nvarchar(50) null
===================================
alter table online_booking
add Status nvarchar(50) null
=============================                    pgs
alter table Sales_Detail
alter column C_Category nvarchar(255) null
alter table Sales_Detail
alter column C_Address nvarchar(Max) null
================================
Alter table Sales_Detail
Add Fur_Tax money,
Fur_Tax_Per money
===============================
Alter table Summary
Add Total_Refund money
===============================
alter table User
Add lati nvarchar(50) null
alter table User
add longi nvarchar(50) null
======================
alter table online_booking
Add notification nvarchar(50) null
=================================
alter table Bill_Hold
Add sale_type nvarchar(100) null
alter table Bill_Hold
add HS_Code nvarchar(50) null
======================================
alter table Summary
alter column Cash_Sale money
alter table Summary
alter column Credit_Sale money
===================================
alter table product
add pic image
===========================
Alter table cust_cate
add salesman nvarchar(50) null
=============================
alter table pos_setting
Add jeweler_bill bit null
update [POS_Setting] set [jeweler_bill] ='False'
=================================================
CREATE TABLE SRO_Items(
Product nvarchar(250) null,
HS_Code	nvarchar(50) null,
SRO_ScheduleNo nvarchar(50) null,
SRO_SerialNo nvarchar(50) null
)
===========================================
Alter Table Temp_Bill
Add SRO_ScheduleNo nvarchar(50) null,
SRO_SerialNo nvarchar(50) null
=================================
alter table Product
alter column Revise_whouse float
==========================================
update [Product] set [Revise_whouse] =[Qty]