CREATE Procedure productByTuijian
(
@Tuijian varchar(20),@rowcount int output
)
AS SELECT
top 4
pdname,
pdtype FROM
ProductBasic WHERE
Tuijian = @Tuijian ORDER BY
Productid DESC
set @rowcount=@@rowcount
(
@Tuijian varchar(20),@rowcount int output
)
AS SELECT
top 4
pdname,
pdtype FROM
ProductBasic WHERE
Tuijian = @Tuijian ORDER BY
Productid DESC
set @rowcount=@@rowcount
解决方案 »
- BCP在远程拷贝数据出异常
- 对带有触发器的表进行修改操作,是否成败都是同步?
- 另一个 SqlParameterCollection 中已包含 SqlParameter。
- 一个数学问题的查询
- 有谁用过BTrieve,如何读出里面的数据?
- 急速给分,但是答案要把道理说透。(100分)
- ODBC中关于Foxpro2.5 for Dos数据库的设置
- 如何把執行存儲過程的結果集寫入到一個鄰時表中
- sql server 6.5 中的临时表的大小,怎莫改,在线等待
- 再sql server里面有没有一个象oracle里面的rowid和rowcount字段!或函数谢谢了
- 急!我的这个update该怎么写
- 请问在VB中用一个简单的方法如果判断一个机器有没有安装EXECL?很急啊?在线等待...
(
@Tuijian varchar(20),@RowNums int
)
AS
set rowcount @RowNums
SELECT
pdname,
pdtype FROM
ProductBasic WHERE
Tuijian = @Tuijian ORDER BY
Productid DESC
GO
@Tuijian varchar(20)
AS SELECT
top 4
pdname,
pdtype FROM
ProductBasic WHERE
Tuijian = @Tuijian ORDER BY
Productid DESC
GO
(
@Tuijian varchar(20)
@rowcount int
)
ASdeclare @sql nvarchar(3000)
set @sql =' SELECT top @row pdname, pdtype FROM ProductBasic WHERE Tuijian = @Tuijian ORDER BY Productid DESC'
exec sp_executesql @sql ,N'@row int',@rowcount
@Tuijian varchar(20),
@rowcount int
AS
declare @sql nvarchar(3000)
set @sql ='SELECT top @row pdname, pdtype FROM ProductBasic WHERE Tuijian = @Tuijian ORDER BY Productid DESC'
exec sp_executesql @sql ,N'@row int',@rowcount
@Tuijian varchar(20),
@rowcount int
AS
declare @sql nvarchar(3000)
set @sql ='SELECT top '+cast(@row as varchar(10)) +' pdname, pdtype FROM ProductBasic WHERE Tuijian = @Tuijian ORDER BY Productid DESC'
exec @sql