代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/173141/5378897
sql altertable.sql
-- alter table tests
-- add column
-- (add constraint & drop constraint to be added)
-- create some database objects
create table t0(c1 int not null constraint p1 primary key);
create table t0_1(c1 i
www.eeworm.com/read/173141/5378900
sql constantexpression.sql
-- tests for constant expression evaluation
autocommit off;
-- create and populate a table
create table t1(c1 int);
insert into t1 values 1, 2, 3;
-- false constant expressions
select * from t1 wher
www.eeworm.com/read/173141/5378903
sql forupdate.sql
--
-- tests for the for update/read only and updatable specifications parts
-- of cursors and positioned statements.
--
-- for positioned update/delete see positionedUpdate.jsql and
-- positionedDelet
www.eeworm.com/read/173141/5378904
sql syscat.sql
--
-- this test shows the system catalogs
--
-- It is a goal of this test not to display information that
-- can (and will!) change from run to run, such as fields
-- that may eventually be UUIDs or U
www.eeworm.com/read/173141/5378905
sql releasecompilelocks.sql
autocommit off;
-- move static initializer tests to front, hoping to avoid class garbage
-- collection in jdk18. Sometimes the static initializer in the
-- DMLInStaticInitializer and InsertInStatic
www.eeworm.com/read/173141/5378907
sql lojreorder.sql
-- This test LOJ reordering.
-- Many testcases are derived from DB2 UDB FVT testcases.
-- Cliff Leung. 10/2002
CREATE TABLE T (A INT NOT NULL, B DECIMAL(10,3) NOT NULL, C VARCHAR(5) NOT NULL);
INSERT
www.eeworm.com/read/173141/5378908
sql dynamiclikeoptimization.sql
-- test the dynamic like optimization
-- NOTE: the metadata test does a bunch
-- of likes with parameters
autocommit off;
-- by default, holdability of ResultSet objects created using this Connectio
www.eeworm.com/read/173141/5378910
sql bit.sql
--
-- Test the builtin type 'bit'
-- Specifically the base-16, hex bit literal
-- stupid test of literals
values(X'aAff');
-- casting to a for bit data type
values (cast (x'ee' as char(2) for bit da
www.eeworm.com/read/173141/5378911
sql aggbuiltin.sql
-- Note that bug 5704 occurs throughout this test
-- Decimal results may be outside the range of valid types in Cloudscape
-- ** insert avg.sql
-- create an all types tables
create table t (i int, s
www.eeworm.com/read/173141/5378914
sql ungroupedaggregatesnegative.sql
-- negative tests for ungrouped aggregates
-- create a table
create table t1 (c1 int);
create table t2 (c1 int);
insert into t2 values 1,2,3;
-- mix aggregate and non-aggregate expressions in the se