潇湘书院的小说:ASP中语句的关键字问题

这个以前好像有人问过的，我再 贴一遍吧:)

这是所有的SQL关键字参考,如果有其他非官方数据库扩展,请查阅相关数据库文档,这些都需要你加[]如果能不用做字段名最好不用,在给数据库、字段等起名子的时候一定不要用以下这些词，虽然有的时候可能没有关系，但是为了避免麻烦还是不用为好。最好的办法起名子的时候都用前缀＋拼音（如果不给外国人看的话）
active
add
all
after
alter
and
any
as
asc
ascending
at
auto
autoinc
avg
before
begin
between
blob
boolean
both
by
bytes
cache
cast
char
character
check
collate
column
commit
committed
computed
conditional
constraint
containing
count
create
cstring
current
cursor
database
date
day
dec
decimal
declare
default
delete
desc
descending
distinct
do
domain
double
drop
else
exists
external
extract
file
filter
float
for
foreign
from
full
function
grant
group
having
hour
if
in
int
inactive
index
inner
insert
integer
into
is
join
key
length
locks
logfile
long
lower
leading
left
level
like
manual
memory
merge
message
min
minute
money
month
names
national
natural
no
nocase
not
null
numeric
of
on
only
option
or
order
outer
page
pages
parameter
password
plan
position
precision
procedure
protected
primary
privileges
real
references
revoke
right
rollback
second
select
set
shared
shadow
schema
size
smallint
some
sort
sqlcode
starting
starts
statistics
substring
sum
table
then
time
timestamp
to
trailing
transaction
trigger
trim
union
unique
update
upper
user
value
values
varchar
variable
varying
view
when
where
while
with
work
write
year