XinXiangXLX_API/文档/Sql/sql_20190604...

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [F_UserId]
      ,[F_UserCode]
      ,[F_Password]
      ,[F_ExtensionNumber]
      ,[F_UserName]
      ,[F_DeptId]
      ,[F_RoleId]
      ,[F_GroupId]
      ,[F_SeatFlag]
      ,[F_SeatRight]
      ,[F_SeatLevel]
      ,[F_SexFlag]
      ,[F_RemindFlag]
      ,[F_Remark]
      ,[F_Telephone]
      ,[F_Mobile]
      ,[F_HomePhone]
      ,[F_Birthday]
      ,[F_CreateOn]
      ,[F_CancelOn]
      ,[F_DeleteFlag]
      ,[F_APPOnFlag]
      ,[F_LastActiveTime]
      ,[F_See]
      ,[F_HJType]
      ,[F_PId]
      ,[F_TmId]
      ,[F_WorkNumber]
      ,[F_DeptCode]
      ,[F_WXNo]
      ,[F_SeartGroupID]
      ,[F_SeartGroup]
      ,[F_WxOpenId]
      ,[RegionId]
  FROM [CallCenter_XinXiangXLX].[dbo].[T_Sys_UserAccount]
  
  --select * from AA_Users
  
  --update T_Sys_UserAccount set F_DeptCode=(select F_DeptCode from T_Sys_Department where T_Sys_UserAccount.F_DeptId=T_Sys_Department.F_DeptId)

  --update T_Sys_UserAccount set F_Mobile=(select F_Mobile from AA_Users where T_Sys_UserAccount.F_UserCode=AA_Users.F_UserCode)
  --insert into T_Sys_UserAccount([F_UserCode],[F_Password],[F_UserName],[F_DeptId],[F_RoleId],[F_SeatFlag],[F_SeatRight],[F_SexFlag],[F_RemindFlag],[F_DeleteFlag],[F_APPOnFlag],[F_WorkNumber],[F_DeptCode])
  --select [F_UserCode],'123456',[F_UserName],[F_DeptId],[F_RoleId],0,0,[F_Sex],0,0,0,[F_UserCode],[F_DeptCode] from AA_Users
  --delete FROM [CallCenter_XinXiangXLX].[dbo].[T_Sys_UserAccount]
  --where F_UserId>1635