/****** Script for SelectTopNRows command from SSMS ******/
SELECT * FROM [gsticket].[dbo].[gstkConsume] where consumeno ='SC190106113625000024' and rentstatus ='0'
UPDATE 表名称 SET 列名称 = 新值 WHERE 列名称 = 某值
update [gsticket].[dbo].[gstkConsume] SET rentstatus='1' where consumeno ='SC190106113625000024' and rentstatus ='0'
--修改租赁状态,是否归还,归还为1,未还为0