商贸版用户表清除语句
云社区用户7mM51234
1人赞赏了该文章
1,531次浏览
编辑于2017年07月24日 10:42:53
--根据用户名清除用户数据
delete t_userprofile where fuserid=(select fuserid from t_user where fname='蒋香艳')
GO
--根据用户名清除打印设置方案
delete t_LedgerPageSetup where fuserid =(select fuserid from t_user where fname='蒋香艳')
go
--根据用户名清除用户报表方案表
delete icreportprofile where fuserid =(select fuserid from t_user where fname='蒋香艳')
go
delete t_userprofile where fuserid=(select fuserid from t_user where fname='蒋香艳')
GO
--根据用户名清除打印设置方案
delete t_LedgerPageSetup where fuserid =(select fuserid from t_user where fname='蒋香艳')
go
--根据用户名清除用户报表方案表
delete icreportprofile where fuserid =(select fuserid from t_user where fname='蒋香艳')
go