代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/173141/5378915
sql temprestrictions.sql
-- Tests for temporary restrictions in the language
-- create a table
create table t1(c1 int);
-- No aggregates in the where clause
-- (Someday will will allow correlated aggregates ...)
select c1 f
www.eeworm.com/read/173141/5378920
sql subqueryflattening.sql
-- test subquery flattening into outer query block
set isolation to rr;
-- tests for flattening a subquery based on a
-- uniqueness condition
-- by default, holdability of ResultSet objects created
www.eeworm.com/read/173141/5378923
sql renameindex.sql
-- rename index tests
--
autocommit off;
--
-- negative tests
--
-- rename a non-existing index
-- should fail because there is no index by name i1t1
rename index i1t1 to i1rt1;
--
-- rename as som
www.eeworm.com/read/173141/5378924
sql miscerrors.sql
--
-- this test is for miscellaneous errors
--
-- lexical error
select @#^%*&! from swearwords;
--
-- try to create duplicate table
--
create table a (one int);
create table a (one int, two int);
www.eeworm.com/read/173141/5378927
sql precedence.sql
-- this tests precedence of operators.
-- test precedence of operators other than and, or, and not
-- that return boolean.
-- expect 'true' row:
create table t1(c11 int);
insert into t1 values(1);
www.eeworm.com/read/173141/5378932
sql views.sql
-- tests for views
-- set autocommit off
autocommit off;
-- create some tables
create table t1(i int, s smallint, f float, dp double precision);
create table t2(i int, s smallint, f float, dp double
www.eeworm.com/read/173141/5378933
sql predicatesintoviews.sql
-- test the pushing of predicates into unflattened views
-- and derived tables
set isolation to rr;
-- by default, holdability of ResultSet objects created using this Connection object is true. Foll
www.eeworm.com/read/173141/5378936
sql dcl.sql
-- test database class loading.
maximumdisplaywidth 300;
create schema emc;
set schema emc;
create table contacts (id int primary key, e_mail varchar(30));
create procedure EMC.ADDCONTACT(id INT, e_
www.eeworm.com/read/173141/5378939
sql staleplans.sql
-- This is the test for stale plan invalidation. The system determines
-- at execution whether the tables used by a DML statement have grown or
-- shrunk significantly, and if so, causes the statemen
www.eeworm.com/read/173141/5378940
sql comparisons.sql
--
-- this test shows the current supported comparison operators
--
-- first, do comparisons on the int type
-- create a table with couple of int columns
create table inttab (c1 int, c2 int);
-- in