参考:declare @tcnt int
declare @paras varchar(100)
DECLARE @SQLString NVARCHAR(500)
set @paras ='1,3,5'
set @sqlstring=N'select @cnt=count(*) from sysobjects where id in ('+@paras+')'set @tcnt=0
execute sp_executesql
@sqlstring,
N'@cnt int output',
@cnt=@tcnt output
select @tcnt
select * from sysobjectsCreate Procedure GetMaxID
@TableName varchar(100), @ID int output
as
begin
declare @sql nvarchar(1000)
set @sql='select @ID = count(ID) from '+@TableName
exec sp_executesql @sql,N'@id int output',@id output
end
declare @paras varchar(100)
DECLARE @SQLString NVARCHAR(500)
set @paras ='1,3,5'
set @sqlstring=N'select @cnt=count(*) from sysobjects where id in ('+@paras+')'set @tcnt=0
execute sp_executesql
@sqlstring,
N'@cnt int output',
@cnt=@tcnt output
select @tcnt
select * from sysobjectsCreate Procedure GetMaxID
@TableName varchar(100), @ID int output
as
begin
declare @sql nvarchar(1000)
set @sql='select @ID = count(ID) from '+@TableName
exec sp_executesql @sql,N'@id int output',@id output
end
解决方案 »
- Sql Server中怎么设置一个字段的值小于另外一个字段的值??
- 请教如何用SQL生成商品流水账
- 对于字节转字符串的处理
- 表中的字段值可以为null,在这些字段之间进行加减乘除运算时,如果一个字段值为null,结果就为null,但是想将这个字段值以0.00来参与运算
- 远端电脑访问本机的access数据库,提示无法启动应用程序,为何?
- rst.close()和pstmt.close()的操作是否多余?是否只进行conn.close()操作就可以了(好像关闭了Connection,ResultSet和PreparedStatement就
- 怎么写一个存储过程,对整个表表进行模糊查询呢?
- 请教:从一个数据表中导出部分数据到另一数据表,并且把导出的部分删除
- (在线等待)如何查找数据库中的所有索引,大侠帮忙!
- 客户端不能连接数据库
- 在存儲過程中能否用傳入參數代替資料表名?
- 为什么SELECT CURRENT_USER不用加括号(),而SELECT USER_NAME()要加括号才能运行呢?
declare @paras varchar(100)
DECLARE @SQLString NVARCHAR(500)
set @paras ='1,3,5'
set @sqlstring=N'select @cnt=count(*) from sysobjects where id in ('+@paras+')'set @tcnt=0
execute sp_executesql
@sqlstring,
N'@cnt int output',
@cnt=@tcnt output
select @tcnt
select * from sysobjectsCreate Procedure GetMaxID
@TableName varchar(100), @ID int output
as
begin
declare @sql nvarchar(1000)
set @sql='select @ID = count(ID) from '+@TableName
exec sp_executesql @sql,N'@id int output',@id output
end
set @TableName = 's_bb0308'
set @sqlstring=N'select @aa = count(bb) from '+@TableName
exec sp_executesql @sqlstring,N'@aaint output',@aa output
set @TableName = 's_bb0308'
Exec(' declare @aa int select @aa = count(*) from ' + @TableName + ' select @aa ')
set @TableName = 's_bb0308'
set @sqlstring=N'select @aa = count(bb) from '+@TableName
exec sp_executesql @sqlstring,N'@aaint output',@aa output
declare @TableName nvarchar(50)
declare @strsql nvarchar(500)
set @TableName='tb_users'
set @strsql=N'select @aa = count(*) from '+@TableName
execute sp_executesql
@strsql,
N'@aa int output',
@aa=@bb outputprint @bb