代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/173141/5378813
sql joins.sql
--
-- this test shows the current supported join functionality
--
-- create some tables
create table t1 (t1_c1 int, t1_c2 char(10));
create table t2 (t2_c1 int, t2_c2 char(10));
create table t3 (t3_c
www.eeworm.com/read/173141/5378815
sql distinct.sql
--
-- tests for DISTINCT
--
-- these tests assume: no indexes, no order by, no grouping
--
-- test plan is represented by '.' items in comments.
-- the flavors of select are shown in distinct.subsql,
www.eeworm.com/read/173141/5378816
sql ddltablelockmode.sql
-- test DDL Table Lock mode
call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
maximumdisplaywidth 2000;
CREATE PROCEDURE WAIT_FOR_POST_COMMIT() DYNAMIC RESULT SETS 0 LANGUAGE JAVA EXTERNAL NAME 'org.ap
www.eeworm.com/read/173141/5378818
sql supersimple.sql
-- by default, holdability of ResultSet objects created using this Connection object is true. Following will set it to false for this connection.
NoHoldForConnection;
create table a (a int);
insert i
www.eeworm.com/read/173141/5378821
sql depend.sql
--
-- this test shows the dependency system in action;
--
autocommit off;
create table t(i int);
create table s(i int);
prepare ins as 'insert into t (i) values (1956)';
prepare ins_s as 'insert i
www.eeworm.com/read/173141/5378822
sql subquery.sql
--
-- subquery tests
--
autocommit off;
CREATE FUNCTION ConsistencyChecker() RETURNS VARCHAR(128)
EXTERNAL NAME 'org.apache.derbyTesting.functionTests.util.T_ConsistencyChecker.runConsistencyChecker'
www.eeworm.com/read/173141/5378831
sql isolationlevels.sql
-- single user test for the various isolation levels
prepare getIsolation as 'values current isolation';
autocommit off;
call SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
maximumdisplaywidth 2000;
--
www.eeworm.com/read/173141/5378833
sql aggregate.sql
-- ** insert aggregatesPositive.sql
autocommit on;
-- General aggregate tests. Aggregate
-- specifics are tested in specific test (e.g. sum.jsql).
--
-- Note that this test does NOT test multiple da
www.eeworm.com/read/173141/5378839
sql infostreams.sql
-- this file exists to show the streams booting and looking at
-- their properties...
www.eeworm.com/read/173141/5378842
sql cast.sql
-- tests for cast expressions
-- refer to casting.java for a complete analysis on casting
--==================================
--
-- simple test cases
--
--==================================
-- shri