帮小弟我看看这个存储过程错哪了？ 对存储过程一窍不通

帮我看看这个存储过程哪里错了？ 对存储过程一窍不通

SQL code

ALTER proc [dbo].[proc_GetPrjWhere]    @Dptid int,    @Userid int,    @PrjCode varchar(20),    @BCreatdate datetime,    @ECreatdate datetimeasdeclare @where varchar(200)set @where = '1=1'exec('select * from Info_prjvalues where ='+@where+'')    

SQL code

declare @where varchar(200)set @where = '1=1'DECLARE @sql VARCHAR(500)SET @sql='select * from Info_prjvalues where ='+@where+''SELECT @sql/*select * from Info_prjvalues where =1=1*/