|
SQL-Server |
Access |
|
Case When Sex='1' Then 'G' Else 'M' End |
IIF(Sex='1','G','M') |
|
Where DataDate = '2011/09/30' |
Where DataDate = #2011/09/30# |
|
Where Mane Like 'ABC%' |
Where Mane Like 'ABC*' |
- 10月 08 週二 201311:22
[VBA][Access與SQL Server的語法差異]
