摘要： use zx_app_dev select identity(int,1,1) as id,EmpID,DeptIds into # from DatEmployee --select * from # SELECT TOP 200000 id = identity(int,1,1) INTO #t FROM syscolumns a, syscolumns b--select EmpID,Cast(DeptID as uniqueidentifier)as deptID from( SELECT A.EmpID, DeptID = SUBSTRING(A.DeptIds, B.ID, C.. 阅读全文