作者：zlt982001
　　将表数据生成SQL脚本的存储过程:
CREATE PROCEDURE dbo.UspOutputData
@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 on
set @objectId=object_id(@tablename)
if @objectId is null -- 判

教程地址：http://www.phprm.com/database/1f8937cf9415390c441c70b9d8699cab.html

欢迎转载！但请带上文章地址^^