ELSE IF(@topnum>0)
BEGIN
IF(@type>0)
SELECT TOP (@topnum)
A.ArticleID,
A.ArticleTitle,
A.ArticleContent,
A.ArticleImg,
PublicDate,
ViewTimes,
A.ArticleType As TypeID,
B.TypeTxt
FROM ArticleInfo A
JOIN TypeInfo B
ON A.ArticleType=B.TypeID
AND A.ArticleType=@type
ORDER BY ArticleID DESC
END
Incorrect syntax near '('.SELECT TOP (@topnum)指的是这一行
BEGIN
IF(@type>0)
SELECT TOP (@topnum)
A.ArticleID,
A.ArticleTitle,
A.ArticleContent,
A.ArticleImg,
PublicDate,
ViewTimes,
A.ArticleType As TypeID,
B.TypeTxt
FROM ArticleInfo A
JOIN TypeInfo B
ON A.ArticleType=B.TypeID
AND A.ArticleType=@type
ORDER BY ArticleID DESC
END
Incorrect syntax near '('.SELECT TOP (@topnum)指的是这一行
BEGIN
IF(@type>0)
EXEC('SELECT TOP ' + @topnum +
' A.ArticleID,
A.ArticleTitle,
A.ArticleContent,
A.ArticleImg,
PublicDate,
ViewTimes,
A.ArticleType As TypeID,
B.TypeTxt
FROM ArticleInfo A
JOIN TypeInfo B
ON A.ArticleType=B.TypeID
AND A.ArticleType=' + @type
' ORDER BY ArticleID DESC'
END
BEGIN
IF(@type>0)
set rowcount @topnum
SELECT
A.ArticleID,
A.ArticleTitle,
A.ArticleContent,
A.ArticleImg,
PublicDate,
ViewTimes,
A.ArticleType As TypeID,
B.TypeTxt
FROM ArticleInfo A
JOIN TypeInfo B
ON A.ArticleType=B.TypeID
AND A.ArticleType=@type
ORDER BY ArticleID DESC
set rowcount 0
END
BEGIN
IF(@type>0)
EXEC('SELECT TOP ' + @topnum +
' A.ArticleID,
A.ArticleTitle,
A.ArticleContent,
A.ArticleImg,
PublicDate,
ViewTimes,
A.ArticleType As TypeID,
B.TypeTxt
FROM ArticleInfo A
JOIN TypeInfo B
ON A.ArticleType=B.TypeID
AND A.ArticleType=' + @type
' ORDER BY ArticleID DESC')
END
set @sql='SELECT TOP '+ (@topnum)+'
A.ArticleID,
A.ArticleTitle,
A.ArticleContent,
A.ArticleImg,
PublicDate,
ViewTimes,
A.ArticleType As TypeID,
B.TypeTxt
FROM ArticleInfo A
JOIN TypeInfo B
ON A.ArticleType=B.TypeID
AND A.ArticleType=@type
ORDER BY ArticleID DESC'exec (@sql)
BEGIN
IF(@type>0)
exec('SELECT TOP '+@topnum+' A.ArticleID,A.ArticleTitle,A.ArticleContent,A.ArticleImg,PublicDate,ViewTimes,A.ArticleType As TypeID,B.TypeTxt FROM ArticleInfo A JOIN TypeInfo B ON A.ArticleType=B.TypeID AND A.ArticleType='+@type+ ' ORDER BY ArticleID DESC')
END
ELSE IF(@topnum>0)
BEGIN
IF(@type>0) EXEC('SELECT TOP ' + @topnum +
' A.ArticleID,
A.ArticleTitle,
A.ArticleContent,
A.ArticleImg,
PublicDate,
ViewTimes,
A.ArticleType As TypeID,
B.TypeTxt
FROM ArticleInfo A
JOIN TypeInfo B
ON A.ArticleType=B.TypeID
AND A.ArticleType=' + @type +
' ORDER BY ArticleID DESC')
END