代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/174902/9569877
sql 各种视图.sql
/*
功能: 水表位置视图
*/
if exists(select * from sysobjects where type='V' and name = 'v_wm_pos')
drop view v_wm_pos
go
create view v_wm_pos
as
select code_name wm_pos, standard_code pos_code, c
www.eeworm.com/read/174686/9577782
sql db.sql
DROP TABLE IF EXISTS `acct`;
CREATE TABLE `acct` (
`id` int(10) unsigned NOT NULL auto_increment,
`record_time` datetime default NULL,
`address` int(10) unsigned NOT NULL default '0',
`
www.eeworm.com/read/170543/9800091
sql 材料查询.sql
select yhbh,cpmc,cpdw,cjmc,lsjg
from wz_cpxx,wz_cpcj,wz_sccj
where wz_cpxx.cpbh=wz_cpcj.cpbh and wz_cpcj.cjbh=wz_sccj.cjbh and cplb='0209';
www.eeworm.com/read/170391/9808222
sql gentable.sql
create table GATHER_USER_DATA(
USER_NAME VARCHAR2(200),
USER_IP VARCHAR2(200),
START_TIME Date,
END_TIME Date,
DURATION INTEGER
);
www.eeworm.com/read/170288/9811858
sql dbllxt.sql
use master
go
--如果存在数据库 dbllxt,则删除之
if exists(select name from sysdatabases where name = 'dbllxt')
drop database dbllxt
go
--新建数据库 dbllxt
--create database dbllxt
--go
CREATE DATABASE [dbllxt
www.eeworm.com/read/366232/9824220
sql create.sql
/*
The primary keys and foreign keys are still missing from this script.
*/
/*
Sequences
*/
CREATE SEQUENCE SEQ_CHILD_OBJECT MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY
www.eeworm.com/read/366232/9824232
sql body.sql
create or replace PACKAGE BODY PKG_GEN AS
function get_version return varchar2 is
begin
return g_version;
end;
function get_procedure_params(
p_table_name in
www.eeworm.com/read/366232/9824233
sql header.sql
create or replace PACKAGE PKG_GEN AS
g_version constant varchar2(200) := '1.0a';
type string_list is table of clob;
function get_version return varchar2;
function generate_merge_pr
www.eeworm.com/read/366108/9832605
sql db.sql
create database supermarket
go
use supermarket
go
create table saled_log(-------消费记录表
sale_man varchar(20),
user_id varchar(20),
pay_time datetime,
pay_money varchar(10)
)
create table a
www.eeworm.com/read/169887/9834220
sql patient.sql
USE Hospital
GO
CREATE TABLE Patient
( Id int IDENTITY PRIMARY KEY,
Name varchar(50),
IDNum varchar(30),
Sex varchar(2),
Age int,
Marry varchar(8)