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