生成表数据脚本的存储过程
CREATE PROCEDURE dbo.OutputData
@tablename sysname
AS
declare @column varchar(1000)
declare @columndata varchar(1000)
declare @sql varchar(4000)
declare @xtype tinyint
declare @name sysname
declare @objectId int
declare @objectname sysname
declare @ident int

set nocount _disibledevent="mailto:'+@TableName+'">'+@TableName+' OFF'

exec OutputData2 '表名'