在SQL Server 2005中如何导出insert脚本

[linhl]

在SQL Server 2005中如何将表中的数据导出成Insert语句，生成一个脚本文件？

[liangpei2008]

没用过2005，估计没有这个功能吧！

[billpu]

以前有用过这样小软件 很小的才几百k 大致就是把表数据生成insert语句 蛮好用的 可以搜索一下

[linhl]

to billpu(加勒比小飞猪):
是什么软件？

[wk_1978]

给你一个通用的存储过程啊




create Proc Spgeninsertsql (@Tablename Varchar(256))

As

Begin

/*当变量的字符数超过8000时，执行存储过程失败。*/
Declare @Sql Varchar(8000)

Declare @Sqlvalues Varchar(8000)

Set @Sql =' ('

Set @Sqlvalues = 'values (''+'

Select @Sqlvalues = @Sqlvalues + Cols + ' + '','' + ' ,@Sql = @Sql + '[' + Name + '],'

From

(Select Case

When Xtype In (48,52,56,59,60,62,104,106,108,122,127)

Then 'case When '+ Name +' Is Null Then ''null'' Else ' + 'cast('+ Name + ' As Varchar)'+' End'

When Xtype In (58,61)

Then 'case When '+ Name +' Is Null Then ''null'' Else '+''''''''' + ' + 'cast('+ Name +' As Varchar)'+ '+'''''''''+' End'

When Xtype In (167)

Then 'case When '+ Name +' Is Null Then ''null'' Else '+''''''''' + ' + 'replace('+ Name+','''''''','''''''''''')' + '+'''''''''+' End'

When Xtype In (231)

Then 'case When '+ Name +' Is Null Then ''null'' Else '+'''n'''''' + ' + 'replace('+ Name+','''''''','''''''''''')' + '+'''''''''+' End'

When Xtype In (175)

Then 'case When '+ Name +' Is Null Then ''null'' Else '+''''''''' + ' + 'cast(Replace('+ Name+','''''''','''''''''''') As Char(' + Cast(Length As Varchar) + '))+'''''''''+' End'

When Xtype In (239)

Then 'case When '+ Name +' Is Null Then ''null'' Else '+'''n'''''' + ' + 'cast(Replace('+ Name+','''''''','''''''''''') As Char(' + Cast(Length As Varchar) + '))+'''''''''+' End'

Else '''null'''

End As Cols,Name

From Syscolumns

Where (Id = Object_Id(@Tablename)) And (Autoval Is Null)

) T

Set @Sql ='select ''insert Into ['+ @Tablename + ']' + Left(@Sql,Len(@Sql)-1)+') ' + Left(@Sqlvalues,Len(@Sqlvalues)-4) + ')'' From '+@Tablename

--Print @Sql

Exec (@Sql)

End

[hyuank]

我初学SQL SERVER,在aspx文件里输入的中文,而SQL SERVER 表里得到的却是一些乱码,帮哈忙嘛