代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/173141/5378863
sql connect.sql
driver 'org.apache.derby.jdbc.EmbeddedDriver';
connect 'jdbc:derby:wombat;create=true';
-- can we run a simple query?
values 1;
-- can we disconnect?
disconnect;
-- can we reconnect?
connect 'jdbc:
www.eeworm.com/read/173141/5378864
sql maxmempertab.sql
autocommit off;
create table tab1 (c1 int, c2 varchar(20000));
create table tab2 (c1 int, c2 varchar(20000));
create table tab3 (c1 int, c2 varchar(2000));
create table tab4 (c1 int, c2 varchar(2000
www.eeworm.com/read/173141/5378866
sql droptable.sql
-- tests for drop table
--
autocommit off;
--
-- test simple table - all should work
--
create table t1 ( a int);
drop table t1;
-- t1 shouldn't be found
select * from t1;
create table t1 (a int);
dro
www.eeworm.com/read/173141/5378875
sql compresstable.sql
-- tests for system procedure SYSCS_COMPRESS_TABLE
-- that reclaims disk space to the OS
run resource 'createTestProcedures.subsql';
maximumdisplaywidth 512;
CREATE FUNCTION ConsistencyChecker() RETU
www.eeworm.com/read/173141/5378879
sql synonym.sql
-- tests for synonym support
set schema APP;
-- negative tests
-- Create a synonym to itself. Error.
create synonym syn for syn;
create synonym syn for APP.syn;
create synonym APP.syn for syn;
create
www.eeworm.com/read/173141/5378880
sql modifycolumn.sql
-- Testing changing the length of a column.
-- Also testing the new syntax for generated column spec and identity attribute
create table alltypes (i int, tn int, s smallint, l bigint,
c char(10)
www.eeworm.com/read/173141/5378889
sql nonreserved.sql
-- This tests that SQL92 formally reserved words are now unreserved
--
-- INTERVAL
create table interval(interval int);
prepare interval as 'select * from interval';
execute interval;
create index in
www.eeworm.com/read/173141/5378892
sql consistencychecker.sql
--
-- this test shows the consistency checker in action;
--
-- create a table with some indexes
create table t1(i int, s smallint, c10 char(10), vc10 varchar(10), dc decimal(5,2));
create index t1_i
www.eeworm.com/read/173141/5378893
sql triggerrefclause.sql
--
-- Test the REFERENCING clause for a trigger
-- as well as a general test that using the
-- OLD and NEW transition variables work ok
--
drop table x;
create table x (x int, y int, z int);
--
-- ne
www.eeworm.com/read/173141/5378895
sql logop.sql
--
-- this test is for logical operators (AND, OR, etc.)
--
-- create a table. Logical operators work on the results of comparisons,
-- which are tested in a separate test, so the types of the column