如何得到 所选数据的 条数 并得到这个值 付给 一个字符串?????? declare @var char(20)select @var = str(count(*)) from RAT_HOLIDAY where holiday_id < 10print @var 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 oracle:set serveroutput ondeclare var varchar2(20); begin select to_char(count(*)) into var from test1; dbms_output.put_line(var); end; select to_char(count(*)) from test_table; i don't see.......能写的具体点吗?比如:把她付给字符串 total declare @var char(20)select @var = str(count(*)) from RAT_HOLIDAY where holiday_id < 10print @var 这样不对吗? select count(*) to char from tablename where condition flowerofwind(现实很残酷)兄的方法应该是对的。declare @count varchar(10)select @count=ltrim(rtrim(str(count(*)))) from yourTable where yourTermprint @count select @count=convert(count(*))from table where…… declare @var char(20)select @var = convert(varchar,count(*)) from RAT_HOLIDAY where holiday_id < 10或select @var = cast(count(*) as varchar ) from RAT_HOLIDAY where holiday_id < 10 declare @total intset @total=(select count(*) from table )看看@total的值:select @total 根据输入的时间段与客户ID号,求一储存过程算出租用天数与合计数量 看看这个,能不能用一条SQl语句实现 求解问题 帮下我 折磨死我了 分布式事务 泪奔.... 如何处理多个同时插入的数据? SQL2000 登陆问题~求助 多条件查询代码,不会写,请教大家!!! 高手看看,难度较大。 客户端如何启动和关闭SERVER服务 ------问一个关于存储过程的问题------请高手帮忙----- sql server中有没有except连接,比如我要将两个表中不同的关键字找出来! 闲来无事,四处转悠,左右无人,测试签名:)
set serveroutput on
declare var varchar2(20);
begin
select to_char(count(*)) into var from test1;
dbms_output.put_line(var);
end;
能写的具体点吗?比如:把她付给字符串 total
select @var = str(count(*)) from RAT_HOLIDAY where holiday_id < 10
print @var
这样不对吗?
declare @count varchar(10)
select @count=ltrim(rtrim(str(count(*)))) from yourTable where yourTerm
print @count
select @var = convert(varchar,count(*)) from RAT_HOLIDAY where holiday_id < 10
或
select @var = cast(count(*) as varchar ) from RAT_HOLIDAY where holiday_id < 10
set @total=(select count(*) from table )看看@total的值:
select @total