代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/216820/14991425
sql createregion.sql
create table region(
R_REGIONKEY int not null primary key check(R_REGIONKEY >= 0),
R_NAME char(25) not null,
R_COMMENT varchar(152) not null
)
www.eeworm.com/read/216820/14991427
sql createencorders.sql
create table enc_orders(o_encvalue varbinary(170) not null,
o_custkey_idx int not null check(o_custkey_idx >= 0),
o_orderdate_idx int not null check(o_orderdate_idx >= 0),
o_shippriority_idx int not
www.eeworm.com/read/216820/14991428
sql rowdiscount.sql
select rownum as num, * into #temp from lineitem
select num, l_discount from #temp order by l_discount
drop table #temp
www.eeworm.com/read/216820/14991429
sql createenccust.sql
create table enc_customer2(c_encvalue varbinary(250) not null,
c_custkey_idx int not null check(c_custkey_idx >= 0)
)
www.eeworm.com/read/216820/14991430
sql createlineitem.sql
create table LINEITEM(
L_ORDERKEY int not null check(L_ORDERKEY >= 0),
L_PARTKEY int not null check(L_PARTKEY >= 0),
L_SUPPKEY int not null check(L_SUPPKEY >= 0),
L_LINENUMBER int not null,
L_QUANTITY
www.eeworm.com/read/216820/14991432
sql rownum.sql
select rownum, * into #temp from lineitem
select * from #temp
where l_shipdate >= to_date('1994-01-01','YYYY-MM-DD')
and l_shipdate < to_date('1995-01-01','YYYY-MM-DD')
drop table #temp
www.eeworm.com/read/216820/14991434
sql createpart.sql
create table part(p_partkey int not null primary key check(p_partkey >= 0),
p_name varchar(55) not null,
p_mfgr char(25) not null,
P_BRAND char(10) not null,
P_TYPE varchar(25) not null,
P_SIZE int
www.eeworm.com/read/216820/14991436
sql createpartsupp.sql
create table PARTSUPP(
PS_PARTKEY int not null check(PS_PARTKEY >= 0),
PS_SUPPKEY int not null check(PS_SUPPKEY >= 0),
PS_AVAILQTY int not null check(PS_AVAILQTY >= 0),
PS_SUPPLYCOST decimal(10, 2) no
www.eeworm.com/read/216820/14991441
sql createsupplier.sql
create table SUPPLIER(
S_SUPPKEY int not null primary key check(S_SUPPKEY >= 0),
S_NAME char(25) not null,
S_ADDRESS varchar(40) not null,
S_NATIONKEY int not null check(S_NATIONKEY >= 0),
S_PHONE