代码搜索：Sql
找到约 10,000 项符合「Sql」的源代码
代码结果 10,000
www.eeworm.com/read/161040/5564033
sql sales.sql
drop table sales;
CREATE TABLE SALES (
ITEM_NUMBER NUMBER,
ITEM_NAME CHAR(30),
SALES_DATE DATE,
COST NUMBER,
SALES_REP_NUMBER NUMBER,
SALES_REP_NAME CHAR(20));
desc sales;
www.eeworm.com/read/161040/5564034
sql createparts.sql
CREATE TABLE PARTS
(ID NUMBER(38)
,DESCRIPTION VARCHAR2(250) NOT NULL
,UNITPRICE NUMBER NOT NULL
,ONHAND NUMBER(38) NOT NULL
,REORDER VARCHAR2(40) NOT NULL
);
INSERT INTO parts
www.eeworm.com/read/161040/5564035
sql map.sql
create or replace procedure insertPart(
id number,
description varchar2,
unitprice number,
onhand number,
reorder number)
as
language java
name 'Part.insert(
oracle.sql.NUMB
www.eeworm.com/read/161040/5564037
sql sales.sql
drop table sales;
CREATE TABLE SALES (
ITEM_NUMBER NUMBER,
ITEM_NAME CHAR(30),
SALES_DATE DATE,
COST NUMBER,
SALES_REP_NUMBER NUMBER,
SALES_REP_NAME CHAR(20));
desc sales;
www.eeworm.com/read/161040/5564040
sql createparts.sql
CREATE TABLE PARTS
(ID NUMBER(38)
,DESCRIPTION VARCHAR2(250) NOT NULL
,UNITPRICE NUMBER NOT NULL
,ONHAND NUMBER(38) NOT NULL
,REORDER VARCHAR2(40) NOT NULL
);
INSERT INTO parts
www.eeworm.com/read/161040/5564044
sql map.sql
create or replace procedure insertPart(
id number,
description varchar2,
unitprice number,
onhand number,
reorder number)
as
language java
name 'Part.insert(
oracle.sql.NUMB
www.eeworm.com/read/159926/5577751
sql data.sql
DELETE FROM admin_help_cat;
DELETE FROM admin_help_entry;
DELETE FROM tech_internal_help_cat;
DELETE FROM tech_internal_help_entry;
DELETE FROM user_help;
DELETE FROM user_help_cats;
DELETE FROM user_
www.eeworm.com/read/159926/5577752
sql settings.sql
INSERT INTO settings VALUES (1,'Allow Registrations','allow_registration','1',2,'If set to \"yes,\" users can register new accounts. If set to \"no,\" no new users can create accounts on your helpdesk
www.eeworm.com/read/159926/5577755
sql install.sql
INSERT INTO languages VALUES (1,'English',1,0,'en','ISO-8859-1','ltr',1);
INSERT INTO languages VALUES (2,'Spanish',1,0,'es','ISO-8859-1','ltr',2);
INSERT INTO languages VALUES (3,'Hebrew',1,0,'he','I
www.eeworm.com/read/159905/5577935
sql dbregister.sql
CREATE PROCEDURE DBRegister
(
@username Varchar( 100 ),
@password Varchar( 100 )
)
AS
IF EXISTS( SELECT u_id
FROM UserList
WHERE u_username=@username )
RETURN - 1
ELSE
INSERT