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谢谢
@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谢谢
解决方案 »
- websphere的ssl,不用https访问websphere?
- 这个功能应该是怎么实现
- c# socket 与 Flash XMLSocket 策略文件传输 问题,高手来~~!!
- asp.net用c# 怎么使用session
- 在asp.net里一般用什么做分析的图(如:曲线图,饼图,柱状图)
- WebControl 内部的HTML如何得到?(在线等!)
- 下周去外企面试,要求精通.net,大家给点意见
- 100分求WEB环境下文档修改痕迹保留如何实现?
- asp.net的button如何点击可以弹出个小窗口!
- 新手求教各位大大~~
- 初学ado.net,想读出数据库的内容大家帮我看一下我的代码哪里出错了?谢谢
- 虽然没分 助人为快乐之本 大家帮小弟看看有关SqlDataAdapter的问题
拼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)
GO
-- Generated By: 武眉博
-- Date Generated: 2006-03-29@top int
asdeclare @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
@ClassID int (4) ,
@topx int (4)
ASdeclare @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)GO
@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)