代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/290357/3977542
sql 分级汇总.sql
--示例
--测试数据
create table tb([DB-ID] varchar(10),ENTITY varchar(10),DATE varchar(10),[CUST-NO] int,AMOUNT decimal(10,2),TAX decimal(10,2))
insert tb select 'RCHQ','001','2004-11-10',200000,100.00,
www.eeworm.com/read/290357/3977543
sql 列转行.sql
--行列转换示例--列变行
--测试数据
create table 表(id int,proc1 decimal(20,1),proc2 decimal(20,1),proc3 decimal(20,1))
insert 表 select 12,3.4,6.7,1.1
union all select 13,5.6,10.3,5.6
union all select 14,7.9,9
www.eeworm.com/read/290357/3977556
sql xml菜单.sql
--生成xml菜单
--示例数据
IF EXISTS(SELECT name FROM sysobjects WHERE name = 'Menu' AND type = 'U')
DROP TABLE Menu
Create table Menu(MenuID tinyint primary key identity,MenuName varchar(20),Comman
www.eeworm.com/read/290309/3980052
sql schema.sql
drop database if exists STOREDB;
create database STOREDB;
use STOREDB;
create table CUSTOMERS (
ID bigint not null auto_increment primary key,
NAME varchar(16) not null,
AGE INT,
ADDR
www.eeworm.com/read/290309/3980078
sql schema.sql
drop database if exists STOREDB;
create database STOREDB;
use STOREDB;
create table CUSTOMERS (
ID bigint not null auto_increment primary key,
NAME varchar(16) not null,
AGE INT,
ADDR
www.eeworm.com/read/290309/3980079
sql schema.sql
drop database if exists STOREDB;
create database STOREDB;
use STOREDB;
create table CUSTOMERS (
ID bigint not null auto_increment primary key,
NAME varchar(16) not null,
AGE INT,
ADDR
www.eeworm.com/read/290307/3980251
sql insert.sql
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES (
'B0500001', '公务员新增', NULL);
INSERT INTO QX_INFORMATION ( ID, NAME, DESCRIBE ) VALUES (
'B0500002', '公务员减少', NULL);
INSERT INTO QX_INF
www.eeworm.com/read/290307/3980279
sql a2.sql
/*******************************
--创建劳动保障公务专项工作统计表a2
*******************************/
create or replace view v_a2_1 as
select a.jcid jcid,a.dwid dwid,c.dwxz dwxz,a.jctj jctj,a.ldzrs ldzrs,decode(b
www.eeworm.com/read/290307/3980281
sql a3.sql
/*******************************
--创建劳动保障公务效果统计表视图
*******************************/
create or replace view v_a3 as
select a.aj_id ajid,a.dwxz dwxz,b.ldzrs ldzrs,b.jctj jctj,c.JCSM_04 qttg,c.JCSM_0
www.eeworm.com/read/290307/3980284
sql a4.sql
/*******************************
--创建劳动保障公务组织统计表视图19a4
*******************************/
create or replace view v_a4_1 as
select ssbz,zjlb,sbsj sj,qx,sfjd
from jcy_ry
/
create or replace vie