You can not use count on uniqueidentifier on MS SQL Server 7. :( Is MSDE 2000 available for download somewhere??
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??
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.