SqlServer2000 do not support this syntax

Category: MS-SQL Server -> Foundation Classes Author: luohuapiaoxue214 Date: 2014-12-14 10:09:29
 
luohuapiaoxue214
2014-12-14 10:09:29
select * from aa where
(clickDate, clickClass) = ('2005-9-9 ', '1')
kaixuanguilai
2014-12-14 10:18:01
seen such a statement.
viphomsai
2014-12-14 10:30:22
seen two brackets around the field with the field values ​​corresponded to
nl447454311
2014-12-14 10:43:53
I tried it, and not to die
aq12qaz
2014-12-14 11:01:08
Never seen
hyw750808
2014-12-14 11:17:48
did not seem to have this way!
you can try the following method
select * from aa where clickDate ; = '2005-9-9 'and clickClass = '1'
yisheng_2009
2014-12-14 11:22:13
Haha, first seen
huanhuaxipan
2014-12-14 11:29:32
Sql-92 should be Support A
wangchuanzhao
2014-12-14 11:34:50
not seen, wondered not, the top