avatar
a*i
1
You can not use count on uniqueidentifier on MS SQL Server 7. :(
Is MSDE 2000 available for download somewhere??
avatar
a*i
2
ugly ugly hack.
count(distinct convert(varchar(36), uniqueid)))
not happy...

【在 a*****i 的大作中提到】
: You can not use count on uniqueidentifier on MS SQL Server 7. :(
: Is MSDE 2000 available for download somewhere??

avatar
g*o
3
right, you can not use count(distinct COLUMN_NAME) in either MS SQL server or
MS ACCESS database,
but you can use this way to solve the problem:
select count(column_name) from select distinct column_name from table_name,
I thought I posted this before.

【在 a*****i 的大作中提到】
: ugly ugly hack.
: count(distinct convert(varchar(36), uniqueid)))
: not happy...

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。