create proc test @filedname varchar(50), @tablename varchar(50) as declare @SQL varchar(8000) set @SQL='select count('+@filedname+') from '+@tablename exec(@SQL)
兄弟,输出呢? cs文件里怎么取得这个统计值呀 不用output嘛?
create proc test @filedname varchar(50), @tablename varchar(50) as select count(@filedname) from @tablename这样比较简单,呵呵
应该需要OUTPUT返回吧把filedname设置成output返回值
看来我已经来晚了,不过一般要加begin end 和go
这样通不过create proc test @filedname varchar(50), @tablename varchar(50) as select count(@filedname) from @tablename这样通过 create proc test @filedname varchar(50), @tablename varchar(50) as declare @SQL varchar(8000) set @SQL='select count('+@filedname+') from '+@tablename exec(@SQL)但是确定不需要output参数嘛?
CREATE PROCEDURE [GetCount] @tablename varchar(50), @count int OUTPUT AS SELECT @count=ISNULL(rows,0) FROM sysindexes WHERE id = object_id(@tablename) AND indid IN (0,1) GO 用这个,速度在毫秒内,缺点是不是实时更新,取值不是最新
SqlCommand cmd = new SqlCommand("test", new SqlConnection(ConnectionString)); cmd.CommandType = CommandType.StoredProcedure; object fieldCount = cmd.ExecuteScalar();
按条件的话用wumylove1234(毁于随) 说的就可以拉
create proc test @filedname varchar(50), @tablename varchar(50) as declare @SQL varchar(8000) set @SQL='select count('+@filedname+') from '+@tablename exec(@SQL)这个没有output的,可以这样调用嘛 ptrParam.Direction =ParameterDirection.Output;
@filedname varchar(50),
@tablename varchar(50)
as
declare @SQL varchar(8000)
set @SQL='select count('+@filedname+') from '+@tablename
exec(@SQL)
cs文件里怎么取得这个统计值呀
不用output嘛?
@filedname varchar(50),
@tablename varchar(50)
as
select count(@filedname) from @tablename这样比较简单,呵呵
@filedname varchar(50),
@tablename varchar(50)
as
select count(@filedname) from @tablename这样通过
create proc test
@filedname varchar(50),
@tablename varchar(50)
as
declare @SQL varchar(8000)
set @SQL='select count('+@filedname+') from '+@tablename
exec(@SQL)但是确定不需要output参数嘛?
@tablename varchar(50),
@count int OUTPUT
AS
SELECT @count=ISNULL(rows,0) FROM sysindexes WHERE id = object_id(@tablename) AND indid IN (0,1)
GO
用这个,速度在毫秒内,缺点是不是实时更新,取值不是最新
cmd.CommandType = CommandType.StoredProcedure;
object fieldCount = cmd.ExecuteScalar();
@filedname varchar(50),
@tablename varchar(50)
as
declare @SQL varchar(8000)
set @SQL='select count('+@filedname+') from '+@tablename
exec(@SQL)这个没有output的,可以这样调用嘛
ptrParam.Direction =ParameterDirection.Output;