ALTER PROCEDURE selectSubCategories
(
@topNum int,
@SupCatID int,
@LanguageID nvarchar(50)
)
AS
select top @topNum * from subcat where (IsActive=1) and (ParentID=@SupCatID) and (LanguageID=@LanguageID) order by CatOrder asc
RETURN 提示@topNum 处出错,似乎不能这么写,请教应该怎么写呢
(
@topNum int,
@SupCatID int,
@LanguageID nvarchar(50)
)
AS
select top @topNum * from subcat where (IsActive=1) and (ParentID=@SupCatID) and (LanguageID=@LanguageID) order by CatOrder asc
RETURN 提示@topNum 处出错,似乎不能这么写,请教应该怎么写呢
ALTER PROCEDURE selectSubCategories
(
@topNum int,
@SupCatID int,
@LanguageID nvarchar(50)
)
AS
DECLARE @SQL VARCHAR(5000)
SET @SQL='select top '+CAST(@topNum AS VARCHAR(50))+' *
from subcat
where (IsActive=1) and (ParentID='+CAST(@SupCatID AS VARCHAR(50))+') and (LanguageID='+@LanguageID+') order by CatOrder asc '
PRINT @SQL
RETURN
ALTER PROCEDURE selectSubCategories
(
@topNum int,
@SupCatID int,
@LanguageID nvarchar(50)
)
AS
exec('select top '+@topNum+' * from subcat where (IsActive=1) and (ParentID='+@SupCatID+') and (LanguageID='+@LanguageID+') order by CatOrder asc')
RETURN
腰缠70元到月入近10万
http://www.hunbei.com.cn/Article/ArticleShow.asp?ArticleID=453IT工程师 毕业4年我年薪涨到30万
http://www.hunbei.com.cn/Article/ArticleShow.asp?ArticleID=51126岁青年坐拥千万域名资产 从小玩家变成CEO
http://www.hunbei.com.cn/Article/ArticleShow.asp?ArticleID=515程序员的酸甜苦辣:告别Coding
http://www.hunbei.com.cn/Article/ArticleShow.asp?ArticleID=341从月薪3500到700万(一)
http://www.hunbei.com.cn/Article/ArticleShow.asp?ArticleID=170网络草根月赚3000的十种方法
http://www.hunbei.com.cn/Article/ArticleShow.asp?ArticleID=517如果我是女的 我肯定不会嫁给做网站的
http://www.hunbei.com.cn/Article/ArticleShow.asp?ArticleID=512