数据库中存储过程的自动化生成 (生成一个库全部存储过程)

具体下面的调用参看我的收藏里面的东西

 

declare @tableName  varchar(256)

DECLARE crAllTable cursor for
 SELECT name
 FROM sysobjects
 WHERE type = 'U' and name <> 'dtproperties'

OPEN crAllTable

FETCH  NEXT
FROM  crAllTable
INTO  @tableName

    
WHILE (@@FETCH_STATUS = 0)
BEGIN
 EXEC pr__SYS_MakeSelectRecordProc @tableName, 1
 EXEC pr__SYS_MakeUpdateRecordProc @tableName, 1
 EXEC pr__SYS_MakeInsertRecordProc @tableName, 1
 EXEC pr__SYS_MakeDeleteRecordProc @tableName, 1
 FETCH  NEXT
 FROM  crAllTable
 INTO @tableName
END

CLOSE crAllTable
DEALLOCATE crAllTable