sql存储过程的问题
---把多个表中的一个数列的值赋给另一个表的列...
create proc L_SelUserOffer
@Name varchar(20)
as
exec('
select favor=((select cast(sum(click)/10 as int) from HS_Y_Mov_2_Movie where Ins_Name='+@Name+')+(select cast(sum(click) as int) from HS_A_Article where InsertName='+@Name+' )+(select cast(sum(click) as int) from HS_LiuYan where UserName=(select ID from HS_U_User where UserName='+@Name+'))) from L_U_offer
')执行不了...求解....分不多请见谅
---把多个表中的一个数列的值赋给另一个表的列...
create proc L_SelUserOffer
@Name varchar(20)
as
exec('
select favor=((select cast(sum(click)/10 as int) from HS_Y_Mov_2_Movie where Ins_Name='+@Name+')+(select cast(sum(click) as int) from HS_A_Article where InsertName='+@Name+' )+(select cast(sum(click) as int) from HS_LiuYan where UserName=(select ID from HS_U_User where UserName='+@Name+'))) from L_U_offer
')执行不了...求解....分不多请见谅
字符型得加上 单引号, 再试试exec('
select favor=((select cast(sum(click)/10 as int) from HS_Y_Mov_2_Movie where Ins_Name='''+@Name+''')+(select cast(sum(click) as int) from HS_A_Article where InsertName='''+@Name+''')+(select cast(sum(click) as int) from HS_LiuYan where UserName=(select ID from HS_U_User where UserName='''+@Name+'''))) from L_U_offer
')
但是单个select cast(sum(click)/10 as int) from HS_Y_Mov_2_Movie 这样就没问题....