代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/343026/11982851
sql 分解公式.sql
/*
分解公式
将公式按运算分解到表中
*/
declare @str varchar(100)
declare @i int,@str1 varchar(10),@str2 varchar(10)
set @str='3+7+12-13+8-9*123' --要分解的字符串
declare @tb table(num varchar(20),operation varcha
www.eeworm.com/read/343026/11982975
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/343026/11982978
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/343026/11983123
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/256538/11990421
sql wygl.sql
www.eeworm.com/read/342759/12001372
sql product.sql
CREATE TABLE Product (Product_Code CHAR(10),Description CHAR(40),
Unit_Price DECIMAL(10,2))
INSERT INTO Product VALUES ('116-064', 'Toaster', 24.95)
INSERT INTO Product VALUES ('257-535', 'Hair dr
www.eeworm.com/read/153822/12004388
sql material.sql
www.eeworm.com/read/153688/12012107
pdf sql语言.pdf
www.eeworm.com/read/153566/12027528