执行该存储过程时报错:

[wangxiao2008]

执行该存储过程时报错:消息 128，级别 15，状态 1，第 2 行
在此上下文中不允许使用名称 "r"。有效表达式包括常量、常量表达式和变量(在某些上下文中)。不允许使用列名。
哪儿写错了???麻烦大家
存储过程为:

CREATE PROCEDURE [dbo].[UP_Analyse_GetInfo]
@ID nvarchar(32)='r',
@Way nvarchar(32)='t',
@Datadtime datetime='2008-02-12'
AS

begin

exec('IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N''[dbo].[T_Temp_Info_'+@UserID+']'') AND type in (N''U''))
DROP TABLE [dbo].[T_Temp_Info_'+@UserID+']
')

declare @strSql nvarchar(200)
select @strSql ='insert into T_Temp_Info_' + @UserId +'(UserId,FinishingDT,FinishingWay)
values('+@UserId+','+Convert(nvarchar(20),@Datadtime)+','+@FinishingWay+')'

Exec(@strSql)

end

[srgcc]

@UserID na er lai de ?

[Limpire]

select @strSql ='insert into T_Temp_Info_' + @UserId +'(UserId,FinishingDT,FinishingWay)
values('''+@UserId+''','''+Convert(varchar,@Datadtime,121)+''','''+@FinishingWay+''')'

[hery2002]

values(''''+@UserId+'''','+Convert(nvarchar(20),@Datadtime)+',''''+@FinishingWay+''')' 

试试

[忆轩辕]

values()里面的字符类型要用''引起来

[hery2002]

values(''''+@UserId+''','+Convert(nvarchar(20),@Datadtime)+','''+@FinishingWay+''')'

[忆轩辕]

select @strSql ='insert into T_Temp_Info_' + @UserId +'(UserId,FinishingDT,FinishingWay)
values('''+@UserId+''','''+Convert(nvarchar(20),@Datadtime)+''','''+@FinishingWay+''')'

[律己修心]

@UserID 为定义

[arrow_gx]

select @strSql ='insert into T_Temp_Info_' + @UserId +'(UserId,FinishingDT,FinishingWay)  
              values('''+@UserId+''','''+Convert(nvarchar(20),@Datadtime)+''','''+@FinishingWay+''')' 

[忆轩辕]

[Quote=引用 7 楼 GDC_ZhaoYZ0304360 的回复:]
@UserID 为定义
[/Quote]

@ID nvarchar(32)应该为 @UserId
@Way nvarchar(32)应该为 +@FinishingWay