select top from where exist join group by having insert into values delete fromalert dropcreate/alert/drop procedure create/alert/drop assert偶现在只写的出这些了,用时查手册
BEGIN END RAISE ID TRANSACTION
像 Select Form Where Delete Drop Table Create Index 之类的应该可以随手写出来吧?
呵呵..你平常写过SQL的存储过程吗?怎么会不知道呢???写几十个出来应该没问题的..beginend if while这些经常用的..应该都是被禁止的关键字吧.
IF ELSE THEN WHERE WHILE FROM WHEN BEGIN END GO WITH IN EXISTS ADD DETELE UPDATE INSERT INTO CREATE PROC PROCEDURE TABLE ALTER DROP AS ON JOIN LEFT RIGHT UNION DEFAULT VARCHAR INNER OUTER ORDEY BY DESC ASC OPTION OVER NULL DEFAULT INDENTITY FOREIGNKEY PRIMARIY KEY IS AND OR GRANT AUTHORISIE EXEC VALUES SELECT GROUP CURSOR EXECUTE COLUMN TRANSCATION TRAN COMMIT ROLLBACK NOT UNIQUE USE TABLE VIEW LIKE PRECENT ....
通过这道题,可以知道,平时使用SQL的应用范围有多大
一个最复杂的SELECT语句就包括了很多关键字
add all alter and any as asc authorization backup begin between break browse bulk by cascade case check checkpoint close clustered coalesce collate column commit compute constraint contains containstable continue convert create cross current current_date current_time current_timestamp current_user cursor database dbcc deallocate declare default delete deny desc disk distinct distributed double drop dummy dump else end errlvl escape except exec execute exists exit fetch file fillfactor for foreign freetext freetexttable from full function goto grant group having holdlock identity identity_insert identitycol if in index inner insert intersect into is join key kill left like lineno load national nocheck nonclustered not null nullif of off offsets on open opendatasource openquery openrowset openxml option or order outer over percent plan precision primary print proc procedure public raiserror read readtext reconfigure references replication restore restrict return revoke right rollback rowcount rowguidcol rule save schema select session_user set setuser shutdown some statistics system_user table textsize then to top tran transaction trigger truncate tsequal union unique update updatetext use user values varying view waitfor when where while with writetext
ADD EXCEPT PERCENT ALL EXEC PLAN ALTER EXECUTE PRECISION AND EXISTS PRIMARY ANY EXIT PRINT AS FETCH PROC ASC FILE PROCEDURE AUTHORIZATION FILLFACTOR PUBLIC BACKUP FOR RAISERROR BEGIN FOREIGN READ BETWEEN FREETEXT READTEXT BREAK FREETEXTTABLE RECONFIGURE BROWSE FROM REFERENCES BULK FULL REPLICATION BY FUNCTION RESTORE CASCADE GOTO RESTRICT CASE GRANT RETURN CHECK GROUP REVOKE CHECKPOINT HAVING RIGHT CLOSE HOLDLOCK ROLLBACK CLUSTERED IDENTITY ROWCOUNT COALESCE IDENTITY_INSERT ROWGUIDCOL COLLATE IDENTITYCOL RULE COLUMN IF SAVE COMMIT IN SCHEMA COMPUTE INDEX SELECT CONSTRAINT INNER SESSION_USER CONTAINS INSERT SET CONTAINSTABLE INTERSECT SETUSER CONTINUE INTO SHUTDOWN CONVERT IS SOME CREATE JOIN STATISTICS CROSS KEY SYSTEM_USER CURRENT KILL TABLE CURRENT_DATE LEFT TEXTSIZE CURRENT_TIME LIKE THEN CURRENT_TIMESTAMP LINENO TO CURRENT_USER LOAD TOP CURSOR NATIONAL TRAN DATABASE NOCHECK TRANSACTION DBCC NONCLUSTERED TRIGGER DEALLOCATE NOT TRUNCATE DECLARE NULL TSEQUAL DEFAULT NULLIF UNION DELETE OF UNIQUE DENY OFF UPDATE DESC OFFSETS UPDATETEXT DISK ON USE DISTINCT OPEN USER DISTRIBUTED OPENDATASOURCE VALUES DOUBLE OPENQUERY VARYING DROP OPENROWSET VIEW DUMMY OPENXML WAITFOR DUMP OPTION WHEN ELSE OR WHERE END ORDER WHILE ERRLVL OUTER WITH ESCAPE OVER WRITETEXT
还有truncate alter rollup cube delete asc desc begin trans commit trans rollback trans view procedure execute job SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON 还有好多
select delete insert from group by order by union all any some left right inner join top lock begin end case function procedure table input output as create alter drop truncate declare for while fetch into next return raiserror try catch view trigger instand of after inserted deleted exec execute null default is not and or having exists cursor scroll go primary key foreign contraint check on rule off set roll back with percent print bulk full restore grant cascade goto open close in index compute clustered unique 呵呵,以防万一,我也想了一下,不知道够不够~~
insert into values
delete fromalert dropcreate/alert/drop procedure
create/alert/drop assert偶现在只写的出这些了,用时查手册
END
RAISE
ID
TRANSACTION
之类的应该可以随手写出来吧?
....
all
alter
and
any
as
asc
authorization
backup
begin
between
break
browse
bulk
by
cascade
case
check
checkpoint
close
clustered
coalesce
collate
column
commit
compute
constraint
contains
containstable
continue
convert
create
cross
current
current_date
current_time
current_timestamp
current_user
cursor
database
dbcc
deallocate
declare
default
delete
deny
desc
disk
distinct
distributed
double
drop
dummy
dump
else
end
errlvl
escape
except
exec
execute
exists
exit
fetch
file
fillfactor
for
foreign
freetext
freetexttable
from
full
function
goto
grant
group
having
holdlock
identity
identity_insert
identitycol
if
in
index
inner
insert
intersect
into
is
join
key
kill
left
like
lineno
load
national
nocheck
nonclustered
not
null
nullif
of
off
offsets
on
open
opendatasource
openquery
openrowset
openxml
option
or
order
outer
over
percent
plan
precision
primary
print
proc
procedure
public
raiserror
read
readtext
reconfigure
references
replication
restore
restrict
return
revoke
right
rollback
rowcount
rowguidcol
rule
save
schema
select
session_user
set
setuser
shutdown
some
statistics
system_user
table
textsize
then
to
top
tran
transaction
trigger
truncate
tsequal
union
unique
update
updatetext
use
user
values
varying
view
waitfor
when
where
while
with
writetext
ALL EXEC PLAN
ALTER EXECUTE PRECISION
AND EXISTS PRIMARY
ANY EXIT PRINT
AS FETCH PROC
ASC FILE PROCEDURE
AUTHORIZATION FILLFACTOR PUBLIC
BACKUP FOR RAISERROR
BEGIN FOREIGN READ
BETWEEN FREETEXT READTEXT
BREAK FREETEXTTABLE RECONFIGURE
BROWSE FROM REFERENCES
BULK FULL REPLICATION
BY FUNCTION RESTORE
CASCADE GOTO RESTRICT
CASE GRANT RETURN
CHECK GROUP REVOKE
CHECKPOINT HAVING RIGHT
CLOSE HOLDLOCK ROLLBACK
CLUSTERED IDENTITY ROWCOUNT
COALESCE IDENTITY_INSERT ROWGUIDCOL
COLLATE IDENTITYCOL RULE
COLUMN IF SAVE
COMMIT IN SCHEMA
COMPUTE INDEX SELECT
CONSTRAINT INNER SESSION_USER
CONTAINS INSERT SET
CONTAINSTABLE INTERSECT SETUSER
CONTINUE INTO SHUTDOWN
CONVERT IS SOME
CREATE JOIN STATISTICS
CROSS KEY SYSTEM_USER
CURRENT KILL TABLE
CURRENT_DATE LEFT TEXTSIZE
CURRENT_TIME LIKE THEN
CURRENT_TIMESTAMP LINENO TO
CURRENT_USER LOAD TOP
CURSOR NATIONAL TRAN
DATABASE NOCHECK TRANSACTION
DBCC NONCLUSTERED TRIGGER
DEALLOCATE NOT TRUNCATE
DECLARE NULL TSEQUAL
DEFAULT NULLIF UNION
DELETE OF UNIQUE
DENY OFF UPDATE
DESC OFFSETS UPDATETEXT
DISK ON USE
DISTINCT OPEN USER
DISTRIBUTED OPENDATASOURCE VALUES
DOUBLE OPENQUERY VARYING
DROP OPENROWSET VIEW
DUMMY OPENXML WAITFOR
DUMP OPTION WHEN
ELSE OR WHERE
END ORDER WHILE
ERRLVL OUTER WITH
ESCAPE OVER WRITETEXT
view procedure execute job SET QUOTED_IDENTIFIER OFF SET ANSI_NULLS ON 还有好多
考官先生,允许我用电脑查吗?SQL联机文档中都有,难道你不知道吗?我没有时间花在记忆这些单词上,难道你不知道记忆信息并不重要,需要时能获得信息并能应用信息才是最重要的吗?很对不起,考官先生,这些关键词我一个也写不出来,不过考官先生,请给我一台装有SQL SERVER的电脑,然后随便出一个要应用SQL语句的任务,我相信我都可以完成。你信不信呢?
你要是.net过硬的话那也没问题。
top lock begin end case function procedure table input output as create alter drop truncate declare for while fetch into next return raiserror try catch view trigger instand of
after inserted deleted exec execute null default is not and or having exists cursor scroll
go primary key foreign contraint check on rule off set roll back with percent print
bulk full restore grant cascade goto open close in index compute clustered unique 呵呵,以防万一,我也想了一下,不知道够不够~~