代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/376006/2718234
sql uuid.sql
-- regression test for the uuid datatype
-- creating test tables
CREATE TABLE guid1
(
guid_field UUID,
text_field TEXT DEFAULT(now())
);
CREATE TABLE guid2
(
guid_field UUID,
text_field TEXT DEF
www.eeworm.com/read/376006/2718236
sql vacuum.sql
--
-- VACUUM
--
CREATE TABLE vactst (i INT);
INSERT INTO vactst VALUES (1);
INSERT INTO vactst SELECT * FROM vactst;
INSERT INTO vactst SELECT * FROM vactst;
INSERT INTO vactst SELECT * FROM vactst;
www.eeworm.com/read/376006/2718237
sql timestamptz.sql
--
-- TIMESTAMPTZ
--
CREATE TABLE TIMESTAMPTZ_TBL (d1 timestamp(2) with time zone);
-- Test shorthand input values
-- We can't just "select" the results since they aren't constants; test for
-- equa
www.eeworm.com/read/376006/2718238
sql domain.sql
--
-- Test domains.
--
-- Test Comment / Drop
create domain domaindroptest int4;
comment on domain domaindroptest is 'About to drop this..';
create domain dependenttypetest domaindroptest;
-- fail
www.eeworm.com/read/376006/2718241
sql tinterval.sql
--
-- TINTERVAL
--
CREATE TABLE TINTERVAL_TBL (f1 tinterval);
-- Should accept any abstime,
-- so do not bother with extensive testing of values
INSERT INTO TINTERVAL_TBL (f1)
VALUES ('["-infin
www.eeworm.com/read/376006/2718263
sql sjis.sql
drop table 寁嶼婡梡岅;
create table 寁嶼婡梡岅 (梡岅 text, 暘椶僐乕僪 varchar, 旛峫1A偩傛 char(16));
create index 寁嶼婡梡岅index1 on 寁嶼婡梡岅 using btree (梡岅);
create index 寁嶼婡梡岅index2 on 寁嶼婡梡岅 using hash (暘椶僐乕僪);
insert into 寁嶼
www.eeworm.com/read/375680/2722723
sql delscore.sql
create TRIGGER DelScore ON Student
FOR DELETE
AS
IF @@RowCount = 0 Return
Declare @ID int
Select @ID=Student_id From Deleted
de
www.eeworm.com/read/375680/2722724
sql delsubject.sql
create TRIGGER DelScore ON Subject
FOR DELETE
AS
IF @@RowCount = 0 Return
Declare @ID int
Select @ID=Subject_id From Deleted
delete
www.eeworm.com/read/375680/2722725
sql delteacher.sql
create TRIGGER DelTeacher ON department
FOR DELETE
AS
IF @@RowCount = 0 Return
Declare @ID int
Select @ID=department_id From Deleted
www.eeworm.com/read/375680/2722726
sql delclass.sql
/******辅导员老师被删除时,删除其所管理的所有班级*****/
create TRIGGER DelClass ON Teacher
FOR DELETE
AS
IF @@RowCount=0 Return
Declare @ID int
Select @ID=teacher_id From Del