代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/173141/5378846
sql select.sql
--
-- this test shows the current supported select functionality
--
create table t(i int, s smallint);
insert into t (i,s) values (1956,475);
-- select a subset of the columns
select i from t;
--
www.eeworm.com/read/173141/5378847
sql update.sql
--
-- this test is for basic update functionality
--
-- create the table
create table t1 (int_col int, smallint_col smallint, char_30_col char(30),
varchar_50_col varchar(50));
create table t2
www.eeworm.com/read/173141/5378848
sql identifier.sql
--
-- this test is for identifiers and delimited idenifiers
-- identifiers get converted to upper case
-- delimited identifiers have their surrounding double quotes removed and
-- any pair of adjacen
www.eeworm.com/read/173141/5378849
sql columndefaults.sql
-- tests for column defaults
-- negative
-- ? in default
create table neg(c1 int default ?);
-- column reference in default
create table neg(c1 int, c2 int default c1);
-- subquery in default
crea
www.eeworm.com/read/173141/5378850
sql stringtypes.sql
--
-- this test shows the current supported char, varchar, and long varchar
-- functionality
--
-- create a table with null and non-null char columns of different lengths
create table ct (c1 char, c
www.eeworm.com/read/173141/5378851
sql triggerbeforetrig.sql
--
-- Consolidated BEFORE trigger tests from all trigger tests.
-- The following tests moved from TriggerValidate.sql to here.
create table x (x int, constraint ck check (x > 0));
create table unrel
www.eeworm.com/read/173141/5378855
sql ejbql.sql
-- This test EJBQL Absolute function. Resolve 3535
-- Begin of ABS/ABSVAL test. For all valid types, un-escaped function.
-- Integer has a range of -2147483648 to 2147483647
-- Basic
create table
www.eeworm.com/read/173141/5378859
sql nulls.sql
--
-- this test shows the current supported null value functionality
--
autocommit off;
-- trying to define null and not null for a column
create table a(a1 int null not null);
-- same as above, exc
www.eeworm.com/read/173141/5378860
sql case.sql
--
-- this test is for keyword case insensitivity
--
-- Try some of the keywords with mixed case. Don't do all of the keywords, as
-- that would be overkill (either that, or I'm too lazy).
cReAtE t
www.eeworm.com/read/173141/5378861
sql nestedcommit.sql
-- by default, holdability of ResultSet objects created using this Connection object is true. Following will set it to false for this connection.
NoHoldForConnection;
-- make sure that we cannot do a