New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

捷信达租赁系统，修改租赁状态 #57

Open

landv opened this issue Sep 6, 2023 · 0 comments

Owner

landv commented Sep 6, 2023

/****** 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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment