ALTER PROCEDURE [dbo].[HomeAdmin_TaskProgress_SelectAllTaskBySomeCondition_p]
@TaskListId INT
,@TaskContent NVARCHAR(100)=NULL
,@TypeId INT=0
,@PlannerId INT =0
,@TransactorId INT =0
,@FinishState INT =0
,@FinishTime DATETIME =NULL
,@OrderByName NVARCHAR(50)
,@OrderBy NVARCHAR(10)
AS
BEGIN
DECLARE @strSql nvarchar(2000)
set @strSql='
SELECT
TaskId,
TaskListId,
TaskTitle,
TaskContent,
TypeId,
PlannerId,
TransactorId,
FinishState,
FinishTime,
[Plan],
Art,
Cooperation,
Youxian,
CreateAdministratorID,
CreateAdministratorName,
CreateTime
FROM TaskProgress_Task_t
WHERE [DISABLE]=0 AND 1=1 AND TaskListId='+cast(@TaskListId as varchar(10))+'
AND ('+@TaskContent+' IS NULL OR TaskContent LIKE ''%'+@TaskContent+'%'')
AND ('+cast(@TypeId as varchar(10))+'=0 OR TypeId='+cast(@TypeId as varchar(10))+')
AND ('+cast(@PlannerId as varchar(10))+'=0 OR PlannerId='+cast(@PlannerId as varchar(10))+')
AND ('+cast(@TransactorId as varchar(10))+'=0 OR TransactorId='+cast(@TransactorId as varchar(10))+')
AND ('+cast(@FinishState as varchar(10))+'=0 OR FinishState='+cast(@FinishState as varchar(10))+')
AND ('+cast(@FinishTime as varchar(20))+' IS NULL OR FinishTime='+cast(@FinishTime as varchar(10))+')
ORDER BY '+ @OrderByName +' '+@OrderBy
EXEC @strSql
END
上面是存储过程，求助各位了
报错 消息 2812，级别 16，状态 62，过程 HomeAdmin_TaskProgress_SelectAllTaskBySomeCondition_p，第 42 行
找不到存储过程 ''。
@TaskContent ,@TypeId ,@PlannerId ,@TransactorId ,@FinishState ,@FinishTime
我查询的时候根据这几个参数查询，不会知道哪个参数会传值过来 也许会一个值也没有
不知道我说清楚没 谢谢
