代码搜索:sql

找到约 10,000 项符合「sql」的源代码

代码结果 10,000
www.eeworm.com/read/216820/14991419

sql createidex.sql

drop index TEST.HELIJUN.IDX
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