代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/173141/5379006
sql cursorerrors.sql
-- What happens when language exceptions are thrown on a next?
-- NOTE: this test is dependent on no optimization, i.e., always getting
-- the same access methods (table scans and join order matching
www.eeworm.com/read/173141/5379008
sql inbetween.sql
--
-- Test IN lists and BETWEEN on the builtin types
-- assumes these builtin types exist:
-- int, smallint, char, varchar, real
--
-- other things we might test:
-- compatibility with dynamic parame
www.eeworm.com/read/173141/5379012
sql insert.sql
--
-- this test is for basic insert functionality
--
-- NOTE: drop, create, select from the same table doesn't work yet either.
-- create the tables
create table t1 (i int, j int);
create table t2
www.eeworm.com/read/173141/5379017
sql intersect.sql
create table t1( id integer not null primary key, i1 integer, i2 integer, c10 char(10), c30 char(30), tm time);
create table t2( id integer not null primary key, i1 integer, i2 integer, vc20 varchar(
www.eeworm.com/read/173141/5379019
sql renametable.sql
-- rename table tests
-- create some database objects
create table t1(c11 int not null primary key);
create table t2(c21 int not null primary key);
create table t3(c31 int not null primary key);
cre
www.eeworm.com/read/173141/5379029
sql outerjoin.sql
-- test outer joins
-- (NO NATURAL JOIN)
autocommit off;
-- create some tables
create table t1(c1 int);
create table t2(c1 int);
create table t3(c1 int);
create table tt1(c1 int, c2 int, c3 int);
www.eeworm.com/read/173141/5379031
sql currentschema.sql
-- test for CURRENT SCHEMA and optional DB2 compatible SET SCHEMA statement
--
-- test SET SCHEMA syntax variations
-- syntax is SET [CURRENT] SCHEMA [=] ( | USER | ? | '')
-- S
www.eeworm.com/read/173141/5379032
sql triggerrecursion.sql
--
-- Trigger recursion test
--
-- test the maximum recursion level to be less than 16
create table t1 (x int);
create table t2 (x int);
create table t3 (x int);
create table t4 (x int);
create table
www.eeworm.com/read/173141/5379033
sql functions.sql
-- Test various functions
create table alltypes(
id int not null primary key,
smallIntCol smallint,
intCol int,
bigIntCol bigint,
floatCol float,
float1Col float(1),
float26Col float(26
www.eeworm.com/read/173141/5379037
sql derived.sql
--
-- this tests derived column lists and derived tables
--
create table s (a int, b int, c int, d int, e int, f int);
create table t (aa int, bb int, cc int, dd int, ee int, ff int);
insert into s