求一sql存诸过程,简单的.
CREATE PROCEDURE UP_KO_Article_GetTopic
@ClassID int (4) ,
@topx int (4)
AS
DECLARE topx int
Select top topx=@topx Title,ArticelID from KO_Article where ClassID=@ClassID order by UpdateTime desc
GO
我写的这个是错的,想实现select top 可以定制,和where classid=@classid
谢谢
问题点数：20、回复次数：7Top
1 楼wudi_1982（向伴水学习|胃出血，住院中）回复于 2006-06-01 16:52:56 得分 0
Select top @topx Title,ArticelID from KO_Article where ClassID=@ClassID order by UpdateTime desc
Top
2 楼xiahouwen（武眉博<活靶子.NET>）回复于 2006-06-01 16:54:49 得分 5
没有测试 大致就这样
拼sql
然后执行
CREATE PROCEDURE UP_KO_Article_GetTopic
@ClassID int (4) ,
@topx int (4)
AS
declare @sql varchar(1000)
set @sql='Select top '+ @topx 'Title,ArticelID from KO_Article where ClassID= ' + @ClassID +' order by UpdateTime desc'
exec(@sql)
GOTop
3 楼xiahouwen（武眉博<活靶子.NET>）回复于 2006-06-01 16:56:52 得分 5
类似
CREATE proc P_GetBbsLatestTopic
-- 从论坛中选取前@top个帖子
-- Generated By: 武眉博
-- Date Generated: 2006-03-29
@top int
as
declare @sql nvarchar(1000)
set @sql='
select distinct top '
+
cast(@top as nvarchar)
+'
t.Topic,
t.LastPosted,
t.TopicID,
t.LastMessageID,
u.UserName,
u.NickName
from
yaf_topic t join yaf_user yu
on yu.UserID = t.UserID
join tb_accounts_user u
on yu.[Name] = u.UserName
order by t.LastPosted desc
'
exec (@sql)
GO
Top
4 楼cncxz（c: (虫虫）回复于 2006-06-01 16:59:28 得分 5
CREATE PROCEDURE UP_KO_Article_GetTopic
@ClassID int (4) ,
@topx int (4)
AS
declare @RecordQuery varchar(5000) --记录查询
set @RecordQuery='SELECT top '+CONVERT(nvarchar, @topx)+' Title,ArticelID from KO_Article where ClassID='+CONVERT(nvarchar, @ClassID)+' order by UpdateTime desc'
exec(@RecordQuery)
GOTop
5 楼lowtemper（小镇姑娘她爹）回复于 2006-06-01 16:59:52 得分 0
Select top @topx Title,ArticelID from KO_Article where ClassID=@ClassID order by UpdateTime descTop
6 楼kssys（）回复于 2006-06-01 17:01:28 得分 5
动态sql,这样写:
CREATE PROCEDURE UP_KO_Article_GetTopic
@ClassID VarChar(4),
@Topx VarChar(4)
AS
DECLARE @Sql VarChar(200)
SET @Sql='Select top '+@Topx+ ' Title,ArticelID from KO_Article where ClassID=' +@ClassID+ ' order by UpdateTime desc'
Exec(@Sql)Top
7 楼pmmx（胖子）回复于 2006-06-02 00:15:36 得分 0
解决了,谢谢各位Top
