代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/173141/5378943
sql authorize.sql
--
-- Create a database with a table and some data.
--
connect 'authorize;create=true' as c1;
create table AUTH_TEST.t1 (a int);
CREATE FUNCTION AUTH_TEST.resourcefile(packageName VARCHAR(50), reso
www.eeworm.com/read/173141/5378948
sql selectivity.sql
-- this test relies heavily on old statistics functionality that is no longer supported and hence taking this test out of nightly suite.
maximumdisplaywidth 5000;
create table two (x int);
insert in
www.eeworm.com/read/173141/5378957
sql arithmetic.sql
--
-- Test the arithmetic operators
--
create table t (i int, j int);
insert into t values (null, null);
insert into t values (0, 100);
insert into t values (1, 101);
insert into t values (-2, -102)
www.eeworm.com/read/173141/5378958
sql unlimited.sql
-- This tests whether we are prevented from creating more than 15 tables
-- in the standard (unlimited) version of the product.
--
create table t1 (x int);
create table t2 (x int);
create table t3 (x
www.eeworm.com/read/173141/5378959
sql lob.sql
-- This test lang/LOB.sql still includes tests for
-- DB2 UDB incompatible datatype NCLOB.
-- Still waiting for DB2 UDB compatible functionality for NCLOB to be implemented
-- Also note that in DB2
www.eeworm.com/read/173141/5378963
sql autoincrement.sql
-- Adding new testcases for DB2 syntax "GENERATED ALWAYS AS IDENTITY"
-- We don't enhance "ALTER TABLE MODIFY COLUMN" yet: DB2 uses "ALTER TABLE ALTER COLUMN..."
-- try generated values with
www.eeworm.com/read/173141/5378965
sql distinctfiltering.sql
-- test filtering of duplicates at language layer
-- for in-order distincts
-- by default, holdability of ResultSet objects created using this Connection object is true. Following will set it to fals
www.eeworm.com/read/173141/5378966
sql joindeadlock.sql
disconnect;
connect 'jdbc:derby:wombat;user=U1' AS C1;
autocommit off;
connect 'jdbc:derby:wombat;user=U2' AS C2;
autocommit off;
set connection C1;
-- user 1 for bug 1573
-- a deadlock when reopeni
www.eeworm.com/read/173141/5378968
sql partdml.sql
--
-- Test partial row access for update and delete
--
maximumdisplaywidth 2000;
drop function getScanCols;
drop table basic;
drop table p;
CREATE FUNCTION getScanCols(value VARCHAR(32672))
www.eeworm.com/read/173141/5378971
sql locktable.sql
-- multiuser lock table tests
disconnect;
connect 'jdbc:derby:wombat;user=U1' AS C1;
autocommit off;
connect 'jdbc:derby:wombat;user=U2' AS C2;
autocommit off;
set connection C1;
-- create a table