各位高手们，帮我看下这个存储过程有什么问题！

[lracky]

use Northwind
go
create procedure SetEmployees1
@Employees varchar(10) output,
@LastName varchar(10),
@FirstName varchar(10)
As


set @Employees=Rtrim(cast(@LastName as varchar(10))) + convert(char(8),getdate(),112) + RTrim(cast(@FirstName as varchar(10)))
go

为什么RTim(cast(@FirstName as varchar(10))的内容不能显示出来啊？
例：我测试时输入LastName=aaa;FirstName=bbb;返回的结果只是@Employee=aaa20031031啊？按理应该是@Employee=aaa20031031bbb啊？
为什么？请教各位高手！

[txlicenhe]

use Northwind
go
create procedure SetEmployees1
@Employees varchar(20) output, -- 你原来设定的宽度不够
@LastName varchar(10),
@FirstName varchar(10)
As


set @Employees=Rtrim(cast(@LastName as varchar(10))) + convert(char(8),getdate(),112) + RTrim(cast(@FirstName as varchar(10)))
go

[txlicenhe]

declare @a varchar(20)
exec SetEmployees1 @a output,'aaa','bbb'
select @a


--------------------
aaa20031031bbb

（所影响的行数为 1 行）

[sheyu8]

把 @Employees 大小改大点就可以咯 varchar(15) output,

[zjcxc]

输出参数的长度问题.

你只定义了10位,当然只能输出10位.