create proc while_User_table as /*獲取用戶表信息游標*/ SET NOCOUNT ON DECLARE find_user_table CURSOR FOR SELECT [name] FROM sysobjects WHERE type='U' and status>=0 /*這裡只查詢用戶定義的表*/ ORDER BY [name] declare @cName VARCHAR(128) /*定義儲存表名變量*/ OPEN find_user_table /*打開游標*/ FETCH NEXT FROM find_user_table INTO @cName /*從游標中讀取表名到變量*/ WHILE @@FETCH_STATUS=0 BEGIN exec make_tigger @cName,'trig_ins_' FETCH NEXT FROM find_user_table INTO @cName /*從游標中讀取表名到變量*/ END CLOSE find_user_table /*關閉游標*/ DEALLOCATE find_user_table /*釋放游標*/ GO 结合 EXEC master..xp_cmdshell 'bcp 数据库..表 out c:\表.txt -c -q -S 服务器实例 -U sa -P sa'
as
/*獲取用戶表信息游標*/
SET NOCOUNT ON
DECLARE find_user_table CURSOR
FOR
SELECT [name] FROM sysobjects
WHERE type='U' and status>=0 /*這裡只查詢用戶定義的表*/
ORDER BY [name]
declare @cName VARCHAR(128) /*定義儲存表名變量*/
OPEN find_user_table /*打開游標*/
FETCH NEXT FROM find_user_table INTO @cName /*從游標中讀取表名到變量*/
WHILE @@FETCH_STATUS=0
BEGIN
exec make_tigger @cName,'trig_ins_'
FETCH NEXT FROM find_user_table INTO @cName /*從游標中讀取表名到變量*/
END
CLOSE find_user_table /*關閉游標*/
DEALLOCATE find_user_table /*釋放游標*/
GO
结合
EXEC master..xp_cmdshell 'bcp 数据库..表 out c:\表.txt -c -q -S 服务器实例 -U sa -P sa'