代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/366271/2892096
sql userinfo.sql
create database jspdev
drop table user_info
CREATE TABLE user_info (
userid nvarchar (40) NOT NULL ,
name nvarchar (40) NOT NULL ,
phone nvarchar (40) NOT NULL ,
www.eeworm.com/read/366271/2892097
sql forum.sql
create table topic(id varchar(30) not null,title varchar(100),author varchar(30),email varchar(50),content varchar(1000),pubtime datetime default getdate(),constraint pk_topic primary key(id));
cre
www.eeworm.com/read/366271/2892179
sql schema.sql
CREATE DATABASE hibdemo DEFAULT CHARSET utf8;
USE hibdemo;
create table sys_user (
id bigint not null auto_increment,
email varchar(255) not null unique,
name varchar(255) not null,
www.eeworm.com/read/365918/2894313
sql sysparm.sql
--添加超级用户
insert into dk_sys_user(yhdm,yhxm,yhmm,jsdm,sldm,yhlb) values('001','超级用户','111','01','0000','00');
--ftp目录和ip地址
insert into dk_sys_parm(ftp_home,ftp_ip,ftp_username,ftp_password) values
www.eeworm.com/read/365918/2894314
sql codetype.sql
insert into dk_sys_code_type values('00', '角色权限');
insert into dk_sys_code_type values('01', '角色类型');
insert into dk_sys_code_type values('02', '银行类别');
insert into dk_sys_code_type values('03', '单
www.eeworm.com/read/365918/2894315
sql fullbuild.sql
--删库
@c:\建库脚本\droptable.sql
--建库
@c:\建库脚本\buildtable.sql
@c:\建库脚本\sysparm.sql
@c:\建库脚本\codetype.sql
@c:\建库脚本\syscode.sql
@c:\建库脚本\dkzcparm.sql
commit;
www.eeworm.com/read/365918/2894318
sql createview.sql
create view gv_per_acct
as
SELECT "G_CO_ACCT"."DWMC", "G_CO_ACCT"."DWDM",
"G_CO_ACCT"."DWDZ", "G_CO_ACCT"."YZBM", "G_CO_ACCT"."SZQX",
"G_CO_ACCT"."ZGBM", "G_CO_ACCT"."LSGX", "G_CO_ACCT"."DWXZ",
"
www.eeworm.com/read/365918/2894320
sql syscode.sql
insert into dk_sys_code(lxdm,dm,dmmc) values('01', '01', '超级用户');
insert into dk_sys_code(lxdm,dm,dmmc) values('01', '02', '管理员');
insert into dk_sys_code(lxdm,dm,dmmc) values('01', '03', '操作员');
www.eeworm.com/read/365918/2894321
sql createuser.sql
CREATE USER "DKTEST" PROFILE "DEFAULT" IDENTIFIED BY "dktest" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK;
GRANT "CONNECT" TO "DKTEST";
GRANT "RESOURCE" TO "DKTEST";