declare @smm_num as varchar(10)
declare @smm_num_1 as varchar(10)
declare @smm_num_2 as varchar(10)set @smm_num=Convert(varchar(6),dateadd(mm,0,getdate()),112)
set @smm_num_1 = 'S'+@smm_num + '01' set @smm_num=Convert(varchar(6),dateadd(mm,1,getdate()),112)
set @smm_num_2 = 'S'+@smm_num + '01'
declare @sql_smmsg_is as varchar(2000)
declare @sql_smmsg_tc as varchar(2000) set @smm_num=Convert(varchar(6),dateadd(mm,0,getdate()),112) set @sql_smmsg_tc= 'Truncate table mpps_21.dbo.smmsg_' + @smm_num + ';'set @sql_smmsg_is = 'Insert into SC22.mpps_21.dbo.smmsg_' + @smm_num + ' ([smm_num]
,[smb_num]
,[smm_id]
,[smm_mobcou]
,[smm_mobare]
,[smm_mobpho]
,[smm_encode]
,[smm_body]
,[smm_oper]
,[smm_retry]
,[smm_txdt]
,[smm_stat]
,[smm_paybch]
,[smm_paycli]
,[smm_tmp_cusid]
,[smm_tmp_cusname]
,[smm_type]
,[smm_relcli]) select * from SC21.MPPS.DBO.smmsgoffline
where smm_num>= ''S20091115'' and smm_num< ''S20091117'';'select @smm_num
select @sql_smmsg_isEXECUTE (@sql_smmsg_is, 'SalesData') AT sc22我用检索出来的 @sql_smmsg_is 内容在数据库服库器运行,没有问题,可以 insert,但上述内容运行就出错了,错误如下:Msg 203, Level 16, State 2, Line 96
The name 'Insert into SC22.mpps_21.dbo.smmsg_200911 ([smm_num]
,[smb_num]
,[smm_id]
,[smm_mobcou]
,[smm_mobare]
,[smm_mobpho]
,[smm_encode]
,[smm_body]
,[smm_oper]
,[smm_retry]
,[smm_txdt]
,[smm_stat]
,[smm_paybch]
,[smm_paycli]
,[smm_tmp_cusid]
,[smm_tmp_cusname]
,[smm_type]
,[smm_relcli]) select * from SC21.MPPS.DBO.smmsgoffline
where smm_num>= 'S20091115' and smm_num< 'S20091117';' is not a valid identifier.
declare @smm_num_1 as varchar(10)
declare @smm_num_2 as varchar(10)set @smm_num=Convert(varchar(6),dateadd(mm,0,getdate()),112)
set @smm_num_1 = 'S'+@smm_num + '01' set @smm_num=Convert(varchar(6),dateadd(mm,1,getdate()),112)
set @smm_num_2 = 'S'+@smm_num + '01'
declare @sql_smmsg_is as varchar(2000)
declare @sql_smmsg_tc as varchar(2000) set @smm_num=Convert(varchar(6),dateadd(mm,0,getdate()),112) set @sql_smmsg_tc= 'Truncate table mpps_21.dbo.smmsg_' + @smm_num + ';'set @sql_smmsg_is = 'Insert into SC22.mpps_21.dbo.smmsg_' + @smm_num + ' ([smm_num]
,[smb_num]
,[smm_id]
,[smm_mobcou]
,[smm_mobare]
,[smm_mobpho]
,[smm_encode]
,[smm_body]
,[smm_oper]
,[smm_retry]
,[smm_txdt]
,[smm_stat]
,[smm_paybch]
,[smm_paycli]
,[smm_tmp_cusid]
,[smm_tmp_cusname]
,[smm_type]
,[smm_relcli]) select * from SC21.MPPS.DBO.smmsgoffline
where smm_num>= ''S20091115'' and smm_num< ''S20091117'';'select @smm_num
select @sql_smmsg_isEXECUTE (@sql_smmsg_is, 'SalesData') AT sc22我用检索出来的 @sql_smmsg_is 内容在数据库服库器运行,没有问题,可以 insert,但上述内容运行就出错了,错误如下:Msg 203, Level 16, State 2, Line 96
The name 'Insert into SC22.mpps_21.dbo.smmsg_200911 ([smm_num]
,[smb_num]
,[smm_id]
,[smm_mobcou]
,[smm_mobare]
,[smm_mobpho]
,[smm_encode]
,[smm_body]
,[smm_oper]
,[smm_retry]
,[smm_txdt]
,[smm_stat]
,[smm_paybch]
,[smm_paycli]
,[smm_tmp_cusid]
,[smm_tmp_cusname]
,[smm_type]
,[smm_relcli]) select * from SC21.MPPS.DBO.smmsgoffline
where smm_num>= 'S20091115' and smm_num< 'S20091117';' is not a valid identifier.
解决方案 »
- 一对多的SQL视图咋搞呢?
- 在线等答案 超基础的SQL2000问题(但是不能解决,自学者抓狂拉)
- sql server 外网远程连接
- 急急急sql sever2008安装出现未知属性错误问题求高手解决
- 数据库死锁的问题
- 高手请进,比较复杂
- SQL 查询
- 一个简单的删除语句
- ********高分求助!! cmd = New System.Data.SqlClient.SqlCommand(sqlstr, cn),我想取得数据库里的数据来使用,该怎么弄?谢谢
- 求助:怎么能在SQL的查询结果里隐藏特定的字词?
- 已经配置好数据库合并复制,想在两表间建立外键约束,怎么总是失败
- 数据库阻塞了,求救,百万火急……
set @sql_smmsg_is = 'Insert into SC22.mpps_21.dbo.smmsg_' + @smm_num + ' ([smm_num]
,[smb_num]
,[smm_id]
,[smm_mobcou]
,[smm_mobare]
,[smm_mobpho]
,[smm_encode]
,[smm_body]
,[smm_oper]
,[smm_retry]
,[smm_txdt]
,[smm_stat]
,[smm_paybch]
,[smm_paycli]
,[smm_tmp_cusid]
,[smm_tmp_cusname]
,[smm_type]
,[smm_relcli]) select * from SC21.MPPS.DBO.smmsgoffline
where smm_num>= ''S20091115'' and smm_num < ''S20091117''最后那个;'不需要.
,[smb_num]
,[smm_id]
,[smm_mobcou]
,[smm_mobare]
,[smm_mobpho]
,[smm_encode]
,[smm_body]
,[smm_oper]
,[smm_retry]
,[smm_txdt]
,[smm_stat]
,[smm_paybch]
,[smm_paycli]
,[smm_tmp_cusid]
,[smm_tmp_cusname]
,[smm_type]
,[smm_relcli]) select * from SC21.MPPS.DBO.smmsgoffline
where smm_num>= ''S20091115'' and smm_num < ''S20091117'''
如果行的话,就说明是这里的问题。我发现其中一就是那个冒号,用来做什么的,第二,就是smm_num>= 'S20091115' 这个怎么比较的,字符串怎么可以比较大小的
冒号??在哪,我这边没有发现阿smm_num>= 'S20091115'应该是可以的阿,我们一直都是这样操作的smm_num是 char(28)的,它是一组以日期时间命名的流水如:'S2009111510111201'
'S2009111510111202'
'S2009111510111203'我们有用过这类型的比较sql语句