我创建了一个连接字符串的存储过程，但是连接完后去不掉里面的空格

[a375559435]

create proc jsj090412_jinchang
(@riqi datetime, @czrenyuan char(10),@wuliaodaima char(10),@jcshuliang int,@remark char(20))
as
begin
set nocount on;
declare @danhao char(20)
declare @driqi char(6), @dczrenyuan char(4),@dwuliaodaima char(4),@djcshuliang char(3)
set @dczrenyuan=(substring(@czrenyuan,7,4))
set @driqi = (convert(varchar(6),@riqi,12))
set @dwuliaodaima = (substring(@wuliaodaima,4,4))
set @djcshuliang = (convert(varchar(3),@jcshuliang))
set @danhao = @driqi+@dczrenyuan+@dwuliaodaima+@djcshuliang
insert into jsj090412_jincangjilu values(@danhao,@riqi,@czrenyuan,@remark,@wuliaodaima,@jcshuliang)
end
go

这是代码，然后：exec jsj090412_jinchang '2009-06-19','0309101412','2134440',50,'无'

结果变成090619 1412 4440 50 到这里
在表了我将@danhao字段的属性设成了char（50）,太短的话会报错
请问我该怎么改成能将那些没用的空格去掉，变成0906191412444050这样呢？

[geniuswjt]

select replace('090619 1412 4440 50',' ','')

/*
0906191412444050

[唐诗三百首]

select replace('090619 1412 4440 50',' ','') 'r'

r
------------------
0906191412444050

[中国风]

怎么喜欢用Char
建议全改为varchar


(convert(varchar(6),@riqi,12))
改为
(convert(varchar(6),@riqi,120))

[中国风]

Create proc jsj090412_jinchang  
(@riqi datetime, @czrenyuan varchar(10),@wuliaodaima varchar(10),@jcshuliang int,@remark varchar(20))   
as
begin
	set nocount on;
	declare @danhao varchar(20)
	declare @driqi varchar(6), @dczrenyuan varchar(4),@dwuliaodaima varchar(4),@djcshuliang varchar(3)
	set @dczrenyuan=(substring(@czrenyuan,7,4))
	set @driqi = (convert(varchar(6),@riqi,12))
	set @dwuliaodaima = (substring(@wuliaodaima,4,4))
	set @djcshuliang = (convert(varchar(3),@jcshuliang))
	set @danhao = @driqi+@dczrenyuan+@dwuliaodaima+@djcshuliang
	select @danhao
	insert into jsj090412_jincangjilu values(@danhao,@riqi,@czrenyuan,@remark,@wuliaodaima,@jcshuliang)
end
go

exec jsj090412_jinchang '2009-06-19','0309101412','2134440',50,'无'


--生成为：0906191412444050

[中国风]

看错楼主要的结果，把变量类型改为varchar就行了，空格是Char造成的

[--小F--]

Char是有可能会产生空格的.

[Rotel-刘志东]

楼主的数据类型用的有问题，最好用varchar()类型，如果用char()容易产生空格。

[ijwsoft]

用varchar