--根据会员卡号来修改会员消费密码;
--USE [db]
--UPDATE [dbo].[membermanage] SET [psw] = '新密码' WHERE [memberno] = '会员卡号'

--示例,会员卡号'ABC123456789',消费密码遗忘,要重新设置为'888888'
USE [db]
UPDATE [dbo].[membermanage] SET [psw] = '888888' WHERE [memberno] = 'ABC123456789'