求大家帮小弟一个忙,看看这个存储过程哪错呢?
if (@assess_sort <> 0)
BEGIN
SET @SQL = @SQL + ' where a.assess_sort = '+Convert(varchar(5),@assess_sort)+ ') and a.assess_sort= '+Convert(varchar(5),@assess_sort)+ ' '
END
ELSE
SET @SQL =@SQL + ') '
END
if (@name <> ' ')
BEGIN
SET @SQL = @SQL + ' where a.assess_title LIKE ' '% '+@name+ '% ' ') and a.assess_title LIKE ' '% '+@name+ '% ' ' '
END
ELSE
SET @SQL =@SQL + ') '
END
EXECUTE (@SQL)
提示关键字 "END "附近有错.
[解决办法]
if (@assess_sort <> 0)
BEGIN --加这个进去
BEGIN
SET @SQL = @SQL + ' where a.assess_sort = '+Convert(varchar(5),@assess_sort)+ ') and a.assess_sort= '+Convert(varchar(5),@assess_sort)+ ' '
END
ELSE
SET @SQL =@SQL + ') '
END
if (@name <> ' ')
BEGIN --加这个进去
BEGIN
SET @SQL = @SQL + ' where a.assess_title LIKE ' '% '+@name+ '% ' ') and a.assess_title LIKE ' '% '+@name+ '% ' ' '
END
ELSE
SET @SQL =@SQL + ') '
END
EXECUTE (@SQL)
[解决办法]
begin end没套好.
if (@assess_sort <> 0)
BEGIN
SET @SQL = @SQL + ' where a.assess_sort = '+Convert(varchar(5),@assess_sort)+ ') and a.assess_sort= '+Convert(varchar(5),@assess_sort)+ ' '
END
ELSE
SET @SQL =@SQL + ') '
END
if (@name <> ' ')
BEGIN
SET @SQL = @SQL + ' where a.assess_title LIKE ' '% '+@name+ '% ' ') and a.assess_title LIKE ' '% '+@name+ '% ' ' '
END
ELSE
begin --这里少了一个.
SET @SQL =@SQL + ') '
END
EXECUTE (@SQL)
