sqlserver导出insert语句的存储过程

执行方法：exec dataToSQLScript @tablename;

CREATE PROCEDURE dbo.dataToSQLScript 
@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 -- 判断对象是否存在 
begin 
print 'The object not exists' 
return 
end 
set @objectname=rtrim(object_name(@objectId))

if @objectname is null or charindex(@objectname,@tablename)=0

begin 
print 'object not in current database' 
return 
end