摘要:
DECLARE @rowsDepartments INT --循环:事业部统计数 DECLARE @dSerialID INT --循环:循环计数 DECLARE @departmentsID INT DECLARE @tmpDepartments TABLE(SerialID INT IDENTI 阅读全文
摘要:
1.MSSQL 2000 DECLARE @tmpDepartments TABLE(SerialID INT IDENTITY(1,1),DepartmentsID INT,DepartmentsCode VARCHAR(50)) --事业部表 CREATE TABLE #tmpAgencies( 阅读全文