34,575
社区成员
发帖
与我相关
我的任务
分享
select cast(cast(1.47E-5 as decimal(18,7)) as char(30))
INSERT INTO
#TMP_NUM(RENSHU)
SELECT
COUNT(*) RENSHU
FROM
STUDENT 学生人数---这个语句是望临时表#TMP_NUM的RENSHU字段中插入STUDENT表的学生人数
SELECT
STUDENTCODE,CLASSCODE,COUNT(*)
FROM
CLASSSELECT
GROUP BY
CLASSCODE
HAVING COUNT(*)=#TMP_NUM.RENSHU---这个语句是查询CLASSSELECT表中与#TMP_NUM表数量一样的STUDENTCODE,CLASSCODE
select cast(cast(1.47E-5 as decimal(18,7)) as char(30))
/*
0.0000147
*/
select cast(1.47E-5 as varchar(30))