当前位置: 代码迷 >> Sql Server >> 存储过程写法出错,请帮小弟我看看
  详细解决方案

存储过程写法出错,请帮小弟我看看

热度:8   发布时间:2016-04-27 18:38:07.0
存储过程写法出错,请帮我看看急
谁能看看我这个存储过程哪里出错了?

CREATE PROCEDURE [dbo].[HasTask]
(
@UID int,
@RETURNVALUE int output
)
 AS
declare @strUID varchar
set 
@strUID = '"[email protected]+'"'
@RETURNVALUE = Select Count(*) from STaskTb as s inner join FTaskTb as f on s.FTID = 

f.FTID where f.Executor like [email protected]%' and s.STID not in 
(Select STID from TUpTb where UID [email protected])
GO



------解决方案--------------------
SQL code
declare @strUID varchar (8000)
  相关解决方案