From Internet
The syntax differences between SQL Server and access are listed below, so that you can easily changeProgramDatabase query.
Date separator number
Access:Pound sign (#)
SQL Server: marker (')
BooleanConstant
Access: True, false; On, off; yes, no; INTEGER:-1 (true), 0 (false ).
SQL Server: INTEGER: 1 (true), 0 (false)
String connection
Access: and (&)
SQL Server: plus sign (+)
Wildcard
Access: The asterisk (*) matches zero or more characters.
Question mark (?) Matches a single character.
Exclamation point (!) This means that the instance is not in the list.
The pound sign (#) indicates a single number.
SQL Server: percent sign (%) matches zero or more characters.
The underscore (_) matches a single character.
The prefix (^) indicates that it is not in the list.
No character corresponding to the pound character.
Drop Index
Access: drop index <index Name> On <Table Name>
SQL Server: drop index <Table Name>. <index Name>
Add an ID column in the table
access: alter table
counter)
SQL SERVER: ALTER TABLE
bigint identity (1, 1) not null