气死我了# Database - 数据库
a*i
1 楼
You can not use count on uniqueidentifier on MS SQL Server 7. :(
Is MSDE 2000 available for download somewhere??
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??
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.
【在 a*****i 的大作中提到】
: ugly ugly hack.
: count(distinct convert(varchar(36), uniqueid)))
: not happy...
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...
相关阅读
找工作sql dev/dba, data analyst, SAS请教高手：想考Oracle的data warehouse认证，不知有没有价值software testing/QA 和database相比，哪个方向更好找工作？这个版人又少了。which sys sp (sql server) show all user sp and functions?Custom Chart Color Palettes in SSRS 2005SQL String questionsqlserver 2008 question请教,如何单步调试sql script?Experts: Oracle database option price hikes no accident (ZZ)发一个在BWI附近的dba 工作发包子，每周一题问个silly questionImport data in RER model and 3NF以后不能站岗了。 (转载)问个问题： Can't connect to MySQL server on 'dbhost' (10061) ( 2003 )请帮我看看，什么地方错了？teradata和oracle比较SQLCODE = -1