BUNUN ALTINA
PHP- Kodu:
CREATE PROCEDURE dbo.UPDATE_WAREHOUSE
@accountid varchar(21),
@Money int,
@dwTime int,
@strItem varchar(1600),
@strSerial varchar(1600)
AS
BUNU EKLE
Kod:
select @money = nMoney from warehouse where straccountid = @accountid
if @money <0
begin
update warehouse set nMoney = '2100000000' where straccountid =@accountid
end
PHP- Kodu:
CREATE PROCEDURE dbo.UPDATE_WAREHOUSE
@accountid varchar(21),
@Money int,
@dwTime int,
@strItem varchar(1600),
@strSerial varchar(1600)
AS
BUNU EKLE
Kod:
select @money = nMoney from warehouse where straccountid = @accountid
if @money <0
begin
update warehouse set nMoney = '2100000000' where straccountid =@accountid
end