- 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 [email protected]+'')
执行后说 “=”号附近有语法错误
------解决方案--------------------
- SQL code
declare @where varchar(200)set @where = '1=1'DECLARE @sql VARCHAR(500)SET @sql='select * from Info_prjvalues where [email protected]+''SELECT @sql/*select * from Info_prjvalues where =1=1*/