代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/173141/5378568
sql backuprestore.sql
--CASE: Tests backup/restore with jar files stored inside the database
create table x (x double precision, y int);
insert into x values (1,1),(10,1),(20,1);
call sqlj.install_jar('extin/brtestjar.jar'
www.eeworm.com/read/173141/5378573
sql encryptionkey.sql
------------------------------------------------------------------------------------
-- This test file contains test cases for testing encryptionKey property in the connection
-- url
--
-- Case 1:
www.eeworm.com/read/173141/5378579
sql readlocks.sql
-- Very basic single user testing of update row locking.
autocommit off;
run resource 'createTestProcedures.subsql';
run resource 'LockTableQuery.subsql';
commit;
call SYSCS_UTIL.SYSCS_SET_DATABASE_P
www.eeworm.com/read/173141/5378645
sql basetab.sql
AUTOCOMMIT OFF;
-- ***************************************************************
-- ****** THIS FILE SHOULD BE RUN UNDER AUTHORIZATION ID HU ******
-- **********************************************
www.eeworm.com/read/173141/5378708
sql flattab.sql
AUTOCOMMIT OFF;
-- ***************************************************************
-- ****** THIS FILE SHOULD BE RUN UNDER AUTHORIZATION ID FLATER **
-- **********************************************
www.eeworm.com/read/173141/5378780
sql schemas.sql
--
-- this test shows the current supported schema functionality, which
-- isn't much. Currently, we have no CREATE SCHEMA statement, though
-- we do understand schema names in table names
--
-- Cata
www.eeworm.com/read/173141/5378781
sql valuesclause.sql
--
-- this test is for the values clause functionality
--
-- create the tables
create table t1 (i int, j int);
create table t2 (k int, l int);
-- populate t2
insert into t2 values (1, 2);
insert in
www.eeworm.com/read/173141/5378786
sql checkconstraint.sql
-- tests for check constraints
autocommit off;
-- negative
-- The following are not allowed in check constraints:
-- ?, subquery, datetime functions
create table neg1(c1 int check(?));
create table
www.eeworm.com/read/173141/5378787
sql refactions.sql
--no cascade delete , just default check
create table t1(a int not null primary key);
create table t2(b int references t1(a));
insert into t1 values (1) , (2) , (3) , (4);
insert into t2 values (1) ,
www.eeworm.com/read/173141/5378788
sql specjplans.sql
-- Test prints query plans for SpecjAppServer2001 benchmark queries.
-- Specifically this test checks for plans generated for tables with no rows to
-- ensure that
-- Index scan must be chosen over