代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/199147/7882535
sql predata.sql
CREATE TABLE TEST(F1 VARCHAR2(10), F2 NUMBER(9, 4),
F3 VARCHAR2(200), F4 FLOAT(126), F5 FLOAT(126), F6 FLOAT(
63));
INSERT INTO TEST(F1, F2, F3, F4, F5, F6)
VALUES('kkkkkkkkkk', 7777
www.eeworm.com/read/434110/7888204
sql checkserverconnectivity.sql
if exists(select 1 from sysobjects where id=object_id('fgetsstatus') and objectproperty(id,'IsInlineFunction')=0)
drop function fgetsstatus
go
create function fgetsstatus(
@servername varchar(
www.eeworm.com/read/199001/7895266
sql test.sql
create table test
(
name text(20) WITH COMPRESSION not null,
score decimal(12,4) not null default 0,
ID smallint not null default 0,
birthday date,
sex char(1),
CONSTRAINT CK_CH_SEX Check
www.eeworm.com/read/399093/7895473
sql library.sql
www.eeworm.com/read/298982/7902483
sql createtable.sql
create table Admininfo(
ano varchar(10) primary key,
aname nvarchar(20) not null,
code varchar(20) not null,
)
create table Department(
dno varchar(6)primary key,
dname nvarchar(20)not n
www.eeworm.com/read/298982/7902504
sql createview.sql
--管理员视图
create view is_adm
as
select * from admininfo
--学生视图
create view is_stu
as
select * from student
--学生信息视图
create view is_stuinfo
as
select sno,sname,sex,dname from student,departm
www.eeworm.com/read/298982/7902521
sql insertdata.sql
--添加院系
insert into department values('001','软件学院');
insert into department values('002','电信学院');
insert into department values('003','外语学院');
insert into department values('004','管理学院');
insert i
www.eeworm.com/read/433847/7906414
sql tables.sql
CREATE TABLE `config` (`value` varchar(255) default NULL,`name` varchar(50) NOT NULL default '')
INSERT INTO `config` VALUES ('北雨聊天室', 'chatroom_name')
INSERT INTO `config` VALUES ('{%%}来了。', 'chatr
www.eeworm.com/read/198790/7910420
sql bookdb.sql
use master
go
IF EXISTS (SELECT *
FROM master..sysdatabases
WHERE name = 'BookDB')
DROP DATABASE BookDB
GO
--创建数据库
create database BookDB
on
(
name='Book_1',
filenam