存储过程写法出错,请帮我看看急
谁能看看我这个存储过程哪里出错了?
CREATE PROCEDURE [dbo].[HasTask]
(
@UID int,
@RETURNVALUE int output
)
  AS
declare @strUID varchar
set  
@strUID = '"'+@UID+'"'
@RETURNVALUE = Select  Count(*)  from STaskTb as s   inner join FTaskTb as f  on s.FTID =  
f.FTID where f.Executor like  '%@UID%'   and s.STID not in  
(Select  STID  from TUpTb where UID =@UID)
GO
------解决方案--------------------
SQL code
declare @strUID varchar (8000)