天殇月痕

摘要： 存储过程中@@ROWCOUNTSQL的系统变量@@ROWCOUNT返回的是上一语句影响的行数。WHILE(@@ROWCOUNT > 0) BEGIN IF(NOT EXISTS (SELECT T_TREE_ID FROM @AFFAIR_OPEN_TREE WHERE T_TREE_ID = @SEARCH_TREE_ID)) INSERT INTO @AFFAIR_OPEN_TREE (T_TREE_ID,T_P_TREE_ID,T_TREE_NAME) SELECT TREE_ID, P_TREE_ID, TREE_NAME FROM T_GOVERNMEN... 阅读全文