各位高手,我写了一个代码,老是出问题,请帮我看看是什么地方出问题了
declare @sql nvarchar(1000),@str nvarchar(1000)
set @sql=N'select a.jh as skjbh,a.flow_no as sklsh,replace(replace(replace(CONVERT(varchar, a.oper_date, 120 ),'-',''),'',''),':','') as sksj,sum(a.sale_price) as hjje into ##z from dbo.pos_t_saleflow a
group by a.flow_no,a.jh,a.oper_date'
execute sp_executesql @sql
就是加了日期转换就出问题了
应该怎么改?
declare @sql nvarchar(1000),@str nvarchar(1000)
set @sql=N'select a.jh as skjbh,a.flow_no as sklsh,replace(replace(replace(CONVERT(varchar, a.oper_date, 120 ),'-',''),'',''),':','') as sksj,sum(a.sale_price) as hjje into ##z from dbo.pos_t_saleflow a
group by a.flow_no,a.jh,a.oper_date'
execute sp_executesql @sql
就是加了日期转换就出问题了
应该怎么改?
解决方案 »
- 如何计算出分组记录所在的页码[sql2000]!
- 请教大家一下,如何让一次select多个,然后每个都能有对应的where判断?
- 去除空格怪问题
- 各位请推荐点好书哈!
- 游标问题
- sql 数字字符在同一个字段中如何排序
- VFP里边有没有作“自然连接”运算的符号或命令
- 急:测试连接sql server时,提示“未与信任sql server连接相关联“
- 百分求SQL语法的详细资料
- 关于SqlServer7.0 数据倒入 数据库,从别的 电脑拷贝过来的 code_data.mdf 和 code_log.ldf
- with as 语句如何提示 materialize
- 高手请进,如何备份代理的作业!不是做数据库的备份。
set @sql=N'select a.jh as skjbh,a.flow_no as sklsh,replace(replace(replace(CONVERT(varchar, a.oper_date, 120 ),''-'',''''),'''',''''),'':'','''') as sksj,sum(a.sale_price) as hjje
into ##z from dbo.pos_t_saleflow a
group by a.flow_no,a.jh,a.oper_date'
execute sp_executesql @sql
单引号中的的单引号
set @sql=N'select a.jh as skjbh,a.flow_no as sklsh,replace(replace(replace(replace(CONVERT(varchar, a.oper_date, 120 ),''-'',''''),'''',''''),'':'',''''),'' '','''') as sksj,sum(a.sale_price) as hjje into ##z from dbo.pos_t_saleflow a
group by a.flow_no,a.jh,a.oper_date'
set @sql=N'select replace(replace(replace(CONVERT(varchar(20), getdate(), 120 ),''-'',''''),'''',''''),'':'','''')
'
execute sp_executesql @sql
----------------------
20100519 125722(1 行受影响)
declare @sql nvarchar(1000),@str nvarchar(1000)
set @sql=N'select a.jh as skjbh,a.flow_no as sklsh,replace(replace(replace('+CONVERT(varchar, a.oper_date, 120+' ),''-'',''''),'''',''''),'':'','''') as sksj,sum(a.sale_price) as hjje into ##z from dbo.pos_t_saleflow a
group by a.flow_no,a.jh,a.oper_date'
execute sp_executesql @sql