runxinzhi.com
首页
百度搜索
测试MSSQL保留字
<HTML> <HEAD><TITLE>验证SQL保留字</TITLE> <SCRIPT LANGUAGE="VBScript"> <!-- function keyword(str) x="action,add,aggregate,all,alter,after,and,as,asc,avg,avg_row_length,auto_increment,between,bigint,bit,binary,blob,bool,both,by,cascade,case,char,character,change,check,checksum,column,columns,comment,constraint,create,cross,current_date,current_time,current_timestamp,data,database,databases,date,datetime,day,day_hour,day_minute,day_second,dayofmonth,dayofweek,dayofyear,dec,decimal,default,delayed,delay_key_write,delete,desc,describe,distinct,distinctrow,double,drop,end,else,escape,escaped,enclosed,enum,explain,exists,fields,file,first,float,float4,float8,flush,foreign,from,for,full,function,global,grant,grants,group,having,heap,high_priority,hour,hour_minute,hour_second,hosts,identified,ignore,in,index,infile,inner,insert,insert_id,int,integer,interval,int1,int2,int3,int4,int8,into,if,is,isam,join,key,keys,kill,last_insert_id,leading,left,length,like,lines,limit,load,local,lock,logs,long,longblob,longtext,low_priority,max,max_rows,match,mediumblob,mediumtext,mediumint,middleint,min_rows,minute,minute_second,modify,month,monthname,myisam,natural,numeric,no,not,null,on,optimize,option,optionally,or,order,outer,outfile,pack_keys,partial,password,precision,primary,procedure,process,processlist,privileges,read,real,references,reload,regexp,rename,replace,restrict,returns,revoke,rlike,row,rows,second,select,set,show,shutdown,smallint,soname,sql_big_tables,sql_big_selects,sql_low_priority_updates,sql_log_off,sql_log_update,sql_select_limit,sql_small_result,sql_big_result,sql_warnings,straight_join,starting,status,string,table,tables,temporary,terminated,text,then,time,timestamp,tinyblob,tinytext,tinyint,trailing,to,type,use,using,unique,unlock,unsigned,update,usage,values,varchar,variables,varying,varbinary,with,write,when,where,year,year_month,zerofill" y=split(x,",") for i=0 to ubound(y) if str=y(i) then keyword=y(i)&"属于保留字" exit for else keyword=str&"不属于保留字" end if next ERASE y msgbox(keyword) end function Sub Button1_OnClick Dim TheForm Set TheForm = Document.ValidForm If len(trim(TheForm.Text1.Value))<=0 Then MsgBox "请输入" Else keyword(TheForm.Text1.Value) End If End Sub --> </SCRIPT> </HEAD> <BODY> <H3>SQL保留字验证</H3><HR> <FORM NAME="ValidForm"> 请输入保留字： <INPUT NAME="Text1" TYPE="TEXT" size=8> <INPUT NAME="Button1" TYPE="BUTTON" VALUE="提交"> </FORM> </BODY> </HTML>
[Ctrl+A 全部选择 提示：你可先修改部分代码，再按运行]
相关阅读:
SpringBoot结合ShardingSphere实现分库分表、读写分离
SpringBoot结合ShardingSphere实现主从读写分离
使用Sentinel实现Spring Cloud Gateway网关流量控制
使用Sentinel实现热点参数限流
对比学习UIKit和AppKit--入门级
UIViewController
C++的异常处理之一：throw是个一无是处的东西
About Closure
理解Objective C 中id
关于文件压缩的一些小知识
原文地址：https://www.cnblogs.com/RuiLei/p/383734.html
最新文章
docker1.4版本devicemapper修改容器硬盘大小
scala tail recursive优化，复用函数栈
Docker搭建便捷的开发者环境
Docker(linux container) 所依赖的底层技术
GoldenGate抽取Informix数据库安装及配置
GoldenGate使用SQLEXEC和GETVAL实现码表关联
GoldenGate 12.3 MA架构介绍系列(5)
ogg12.2中的新参数 AllowOutputDir
GoldenGate for Java adapter介绍二（代码篇）
GoldenGate for Java Adapter介绍一(原理篇)
热门文章
GoldenGate BR(bounded Recovery)简单说明
GoldenGate12.3中新增的Parallel Replicat (PR)介绍
GoldenGate实时投递数据到大数据平台（7）– Apache Hbase
使用隐含参数testMappingSpeed排查GoldenGate抽取慢的步骤
Nginx系列之3：反向代理和负载均衡
Nginx系列之2：安全
Nginx系列之1：限流
MySQL性能分析（Explain）
MySQL事务隔离级别
MySQL聚集索引和非聚集索引
Copyright © 2020-2023
润新知