| 12345678910111213 |
- /****** Script for SelectTopNRows command from SSMS ******/
- SELECT *
- FROM [CallCenter_XinXiangXLX].[dbo].[T_Sys_UserAccount]
-
- --update T_Sys_UserAccount set F_Password='123456',F_SeatFlag=0,F_RemindFlag=0,F_DeptCode=(select F_DeptCode from T_Sys_Department where T_Sys_Department.F_DeptId=T_Sys_UserAccount.F_DeptId),F_WorkNumber=F_UserCode
- --where F_UserId>1635
- --update T_Sys_UserAccount set F_WorkNumber=F_UserCode
- --where F_UserId>1635
-
- --delete from T_Sys_UserAccount where F_UserId>1635
-
- --insert into T_Sys_UserAccount(F_UserCode,F_UserName,[F_DeptId],[F_RoleId],[F_SexFlag],[F_Telephone],F_Password,F_SeatFlag,F_RemindFlag,F_DeptCode)
- --select F_UserCode,姓名,[F_DeptId],[F_RoleId],[F_SexFlag],[F_Telephone],'123456',0,0,(select F_DeptCode from T_Sys_Department where T_Sys_Department.F_DeptId=Sheet_users.F_DeptId) deptcode from Sheet_users
|
