27,582
社区成员




--出来的是字符型.
select id = right('0000000000' + cast(cast(rand(checksum(newid()))*1000000000 as int) as varchar),10) from sysobjects
--如果要INT(估计得bigint才行)
select id = cast(left(cast(cast(rand(checksum(newid()))*1000000000 as int) as varchar) + '0000000000',10) as bigint) from sysobjects
select cast(cast(replace(newid(),'-','')as binary)as bigint)
--随然感觉用处不大 学习方丈 抛砖引玉...
select
b.科目ID,b.科目编码,b.科目名称,sum(c.借方金额) as [借方金额],sum(c.贷方金额) as [贷方金额]
from
@科目表 a
join
@科目表 b on a.科目编码 like b.科目编码+'%'
join
@业务发生表 c on c.科目ID=a.科目ID
where
a.科目ID in (102,105)
group by b.科目ID,b.科目编码,b.科目名称
a.科目编码 like b.科目编码+'%'