代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/440502/7068525
sql autoproc.sql
--自动投档程序AUTOPROC
CREATE OR REPLACE PROCEDURE AUTOPROC(P_LQZY NUMBER)
AS
CURSOR COLLEGE_CURSOR IS SELECT 院校编号 FROM COLLEGE;
BEGIN
FOR COLLEGE_REC IN COLLEGE_CURSOR LOOP
IF (P_LQZ
www.eeworm.com/read/440502/7068528
sql getstudentname.sql
CREATE OR REPLACE FUNCTION GET_STUDENT_NAME(P_BH NUMBER)
RETURN VARCHAR2
AS
V_NAME VARCHAR2(10);
BEGIN
SELECT 姓名 INTO V_NAME FROM STUDENT WHERE 编号=P_BH;
RETURN(V_NAME);
EXC
www.eeworm.com/read/440502/7068532
sql clearstatus.sql
--投档初始化过程CLEARSTATUS
CREATE OR REPLACE PROCEDURE CLEARSTATUS
AS
BEGIN
UPDATE COLLEGE SET 录取人数=0;
UPDATE NOTE SET TIMES=0;
UPDATE STUDENT SET 录取状态=0,录取志愿=NULL,录取院校=NULL,录取日期=NULL,操作人=NU
www.eeworm.com/read/440502/7068533
sql createresultview.sql
--步骤1：建立视图：
CREATE OR REPLACE VIEW 录取考生(编号,姓名,录取院校名称)
AS SELECT 编号,姓名,院校名称 FROM student,college
WHERE 录取状态='1' AND student.录取院校=college.院校编号
WITH READ ONLY;
--步骤2：生成录取考生视图的同义词RESULT：
www.eeworm.com/read/440502/7068536
sql createstatusview.sql
--步骤1：创建视图：
CREATE OR REPLACE VIEW 录取情况(院校编号,院校名称,状态,招生人数,缺额)
AS SELECT 院校编号,院校名称,DECODE(SIGN(招生人数-录取人数),1,'未完成','完成'),招生人数,招生人数-录取人数
FROM college WITH READ ONLY;
--步骤2：生成录取情况视图的同义词STATUS
www.eeworm.com/read/440502/7068542
sql createscoreview.sql
--步骤1：创建视图：
CREATE OR REPLACE VIEW 考生成绩(编号,姓名,总分)
AS SELECT 编号,姓名,总分 FROM student
WITH READ ONLY;
--步骤2：生成考生成绩视图的同义词score：
CREATE SYNONYM SCORE FOR 考生成绩;
www.eeworm.com/read/349429/7072760
sql hotel.sql
if exists (select * from sysdatabases where name='Hotel')
drop database Hotel
exec xp_cmdshell ' md E:\HotelDB'
create database Hotel
on primary
(
name='Hotel_dat',
filename='E:\HotelDB\Hot
www.eeworm.com/read/101065/7083808
sql cuijiao.sql
CREATE TABLE t_data_cuijiao (
hth varchar2(20),
qianfei number(10, 2),
qfmonth number(4, 0),
flag char(1),
cjcount number(4, 0),
cjmonth number(4, 0),
cjyin_flag number(2,0));
www.eeworm.com/read/318714/7086229
gif sql.gif
www.eeworm.com/read/318714/7086442
gif sql.gif
vti_encoding:SR|utf8-nl
vti_timelastmodified:TR|18 Dec 2002 18:36:48 -0000
vti_extenderversion:SR|6.0.2.5516
vti_author:SR|WORK\\Administrator
vti_modifiedby:SR|WORK\\Administrator
vti_timecreate