这样修改:
table1
PKId CommandText
1 SELECT COUNT(*) FROM tab1 WHERE EmployeeId = @EmployeeId
2 SELECT MAX(score) FROM tabl2 WHERE EmployeeId = @EmployeeId
3 SELECT AVE(laborage) FROM tabl2 WHERE EmployeeId = @EmployeeId
...
DECLARE @CommandText varchar(800)
DECLARE @EmployeeId varchar(50)
SET @EmployeeId = 1DECLARE table1_cursor CURSOR
FOR
SELECT left(CommandText,len(CommandText)-11)
FROM table1
Open table1_cursorFETCH NEXT FROM table1_cursor
INTO @CommandTextWHILE @@FETCH_STATUS = 0
BEGIN
set @CommandText=@CommandText+@EmployeeId
EXEC (@CommandText)
FETCH NEXT FROM table1_cursor
END
CLOSE table1_cursor
table1
PKId CommandText
1 SELECT COUNT(*) FROM tab1 WHERE EmployeeId = @EmployeeId
2 SELECT MAX(score) FROM tabl2 WHERE EmployeeId = @EmployeeId
3 SELECT AVE(laborage) FROM tabl2 WHERE EmployeeId = @EmployeeId
...
DECLARE @CommandText varchar(800)
DECLARE @EmployeeId varchar(50)
SET @EmployeeId = 1DECLARE table1_cursor CURSOR
FOR
SELECT left(CommandText,len(CommandText)-11)
FROM table1
Open table1_cursorFETCH NEXT FROM table1_cursor
INTO @CommandTextWHILE @@FETCH_STATUS = 0
BEGIN
set @CommandText=@CommandText+@EmployeeId
EXEC (@CommandText)
FETCH NEXT FROM table1_cursor
END
CLOSE table1_cursor
DECLARE @EmployeeId varchar(50)
SET @EmployeeId = 'jarod'DECLARE table1_cursor CURSOR
FOR
SELECT left(CommandText,len(CommandText)-11)
FROM table1
Open table1_cursorFETCH NEXT FROM table1_cursor
INTO @CommandTextWHILE @@FETCH_STATUS = 0
BEGIN
set @CommandText=@CommandText+@EmployeeId
EXEC (@CommandText)
FETCH NEXT FROM table1_cursor
END
CLOSE table1_cursor
我测试过了,没有问题的。