XinXiangXLX_API/文档/Sql/sql_20190603...

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