|
pb9+SQLserver2k下通过
先建表A_Imp_Insert_Sql
if exists (select * from dbo.sysobjects where id = object_id(N''''[dbo].[A_Imp_Insert_Sql]'''') and OBJECTPROPERTY(id, N''''IsUserTable'''') = 1)
drop table [dbo].[A_Imp_Insert_Sql]
GO
CREATE TABLE [dbo].[A_Imp_Insert_Sql] (
[insertsql] [varchar] (8000) COLLATE Chinese_PRC_CI_AS NULL ,
[flag] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
建存储过程proc_insert
CREATE proc proc_insert (@ls_server varchar(256),@ls_user varchar(20),@ls_pwd varchar(20),@tablename varchar(30),@ls_colName varchar(20),@ls_operator varchar(10),@str_bookid varchar(100))
as
begin
set nocount on
declare @sqlstr varchar(8000)
declare @sqlstr1 varchar(8000)
declare @sqlstr2 varchar(8000)
--改为在pb中删除表.
--exec( ''''truncate table A_Imp_Insert_Sql'''')
--insert into A_Imp_Insert_Sql
--A_CLS_Temp
if @tablename =''''A_CLS_Temp''''
begin
-- 单独处理了，特殊对待
select @sqlstr='''' select ''''''''insert ChineseLibraryClass ''''
end
else
begin
select @sqlstr='''' select ''''''''insert ''''+@tablename
end
-- select @sqlstr='''' select ''''''''insert ''''+@tablename
select @sqlstr1=''''''''
select @sqlstr2='''' (''''
select @sqlstr1= '''' values ( ''''''''+''''
select @sqlstr1=@sqlstr1+col+''''+'''''''',''''''''+'''' ,@sqlstr2=@sqlstr2+name +'''','''' from (select case
-- when a.xtype =173 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(''''+convert(varchar(4),a.length*2+2)+''''),''''+a.name +'''')''''+'''' end''''
when a.xtype =104 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(1),''''+a.name +'''')''''+'''' end''''
when a.xtype =175 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''''''''''''''''''''''''''''''''''+''''+''''replace(''''+a.name+'''','''''''''''''''''''''''''''''''','''''''''''''''''''''''''''''''''''''''''''''''')'''' + ''''+''''''''''''''''''''''''''''''''''''+'''' end''''
when a.xtype =61 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''''''''''''''''''''''''''''''''''+''''+''''convert(varchar(23),''''+a.name +'''',121)''''+ ''''+''''''''''''''''''''''''''''''''''''+'''' end''''
when a.xtype =106 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(''''+convert(varchar(4),a.xprec+2)+''''),''''+a.name +'''')''''+'''' end''''
when a.xtype =62 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(23),''''+a.name +'''',2)''''+'''' end''''
when a.xtype =56 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(11),''''+a.name +'''')''''+'''' end''''
when a.xtype =60 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(22),''''+a.name +'''')''''+'''' end''''
when a.xtype =239 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''''''''''''''''''''''''''''''''''+''''+''''replace(''''+a.name+'''','''''''''''''''''''''''''''''''','''''''''''''''''''''''''''''''''''''''''''''''')'''' + ''''+''''''''''''''''''''''''''''''''''''+'''' end''''
when a.xtype =108 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(''''+convert(varchar(4),a.xprec+2)+''''),''''+a.name +'''')''''+'''' end''''
when a.xtype =231 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''''''''''''''''''''''''''''''''''+''''+''''replace(''''+a.name+'''','''''''''''''''''''''''''''''''','''''''''''''''''''''''''''''''''''''''''''''''')'''' + ''''+''''''''''''''''''''''''''''''''''''+'''' end''''
when a.xtype =59 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(23),''''+a.name +'''',2)''''+'''' end''''
when a.xtype =58 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''''''''''''''''''''''''''''''''''+''''+''''convert(varchar(23),''''+a.name +'''',121)''''+ ''''+''''''''''''''''''''''''''''''''''''+'''' end''''
when a.xtype =52 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(12),''''+a.name +'''')''''+'''' end''''
when a.xtype =122 then ''''case when ''''+a.name+'''' is null then ''''''''NULL'''''''' else ''''+''''convert(varchar(22),''''+a.name +'''')''''+'''' end''''
[1] [2] 下一页
[Access]sql随机抽取记录 [Access]ASP&SQL让select查询结果随机排序的实现方法
[系统软件]SQL语句性能优化--LECCO SQL Expert [C语言系列]SQL Server到DB2连接服务器的实现
[C语言系列]SQL Server到SYBASE连接服务器的实现 [C语言系列]SQL Server到SQLBASE连接服务器的实现
[C语言系列]SQL Server连接VFP数据库的实现 [C语言系列]ASP+SQL Server之图象数据处理
[C语言系列]SQL Server连接ACCESS数据库的实现 [C语言系列]DBA的最佳选择—图形界面还是T-SQL命令？
|
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
