search

landv / landv.github.io

landv-blogs
https://landv.cn
2 stars 0 forks source link

捷信达修改租赁门票销售数据SQL #54

Open landv opened 1 year ago

landv commented 1 year ago 
--修改租赁门票销售数据

SELECT *  FROM [gsticket].[dbo].[gssaletkdetail] where saleno ='GSSA915700003597'
--UPDATE 表名称 SET 列名称 = 新值 WHERE 列名称 = 某值
UPDATE [gsticket].[dbo].[gssaletkdetail] SET price='19.9',amt='19.9',factamt='19.9',oriprice='19.9' where saleno ='GSSA915700003597'

SELECT *  FROM [gsticket].[dbo].[gssaletkhead] where saleno='GSSA915700003597'
UPDATE [gsticket].[dbo].[gssaletkhead] SET sumamt='59.7',factamt='59.7',pay_amt='59.7' where saleno ='GSSA915700003597'