代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/177407/5327886
sql history.sql
DECLARE
-- Get Tables
CURSOR Cur_Tables IS
SELECT TableName
FROM AD_Table
WHERE TableName LIKE 'C_Order';-- OR TableName LIKE 'C_Invoice%';
-- Column Definition
CURSOR Cur_Columns
www.eeworm.com/read/177407/5327888
sql updatefk.sql
/*************************************************************************
* The contents of this file are subject to the Compiere License. You may
* obtain a copy of the License at http://www
www.eeworm.com/read/177407/5327889
sql docstatusaction.sql
SELECT Value "Status(131)", Name
FROM AD_Ref_List WHERE AD_Reference_ID=131 ORDER BY 1;
SELECT Value "Action(135)", Name
FROM AD_Ref_List WHERE AD_Reference_ID=135 ORDER BY 1
www.eeworm.com/read/177407/5327890
sql usererrors.sql
SELECT * FROM User_Errors;
-- SELECT DBMS_JAVA.LONGNAME(Name), Text FROM User_Errors ORDER BY 1
www.eeworm.com/read/177407/5327897
sql performance.sql
/**
* Rebuild Indexes with BLevel >= 4
*/
--SELECT Index_Name, BLevel FROM USER_Indexes WHERE BLevel >= 4
--ALTER INEX x REBUILD
/**
* Hit rate of index
*/
SELECT i.Index_Name, i.T
www.eeworm.com/read/177407/5327898
sql cursors.sql
/**
* Cursor Test
* $Id: cursors.sql,v 1.2 2002/04/26 03:21:44 jjanke Exp $
*/
DECLARE
-- Global Variables
v_Name AD_Client.Name%TYPE;
-- Counter
v_no NUMBER;
BEGIN
-- ========
www.eeworm.com/read/177407/5327899
sql renametable.sql
-- Rename Table
RENAME SO_Charge TO C_Charge;
UPDATE AD_Table SET TableName='C_Charge' WHERE UPPER(TableName)='SO_CHARGE';
COMMIT;
www.eeworm.com/read/177407/5327901
sql renamecolumn.sql
-- Rename Column
-- a) Add new Column to Table & copy data
ALTER TABLE C_Charge ADD C_Charge_ID Number(10);
UPDATE C_Charge SET C_Charge_ID = SO_Charge_ID;
-- b) Change in Dictionary
UPDATE AD
www.eeworm.com/read/177255/5330760
sql order.sql
CREATE TABLE order_item (
order_item_id int(11) DEFAULT '0' NOT NULL auto_increment,
order_id int(11),
user_info_id int(11),
vendor_id int(11),
product_id int(11),
product_quantity int(11)