谁能看看我这个存储过程哪里出错了?
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)