代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/376468/2710522
sql gzry.sql
create table gzry( //工作人员表
bm char(4) not null,
xm char(10) not null,
constraint p_gzry primary key nonclustered (bm) on 'default');
www.eeworm.com/read/376468/2710523
sql tsd.sql
CREATE TABLE dbo.tsd (
flowcode char(12) not null ,
feedate smalldatetime not null ,
paymonth char(20) not null ,
fkdwcode char(6) not null ,
fkdwfullname char(40) not null ,
fkdwcou
www.eeworm.com/read/376468/2710524
sql tollitem.sql
create table tollitem(
hoscode char(4) not null, //医院编码
code char(16) not null, //收费项目编码
itemname char(60) not null, //收费项目名称
itemtype char(10) not null, //收费类型
pycode char(10) null,
www.eeworm.com/read/376468/2710525
sql cardinfo.sql
create table cardinfo(
iccard char(10) not null, //IC卡号
unitcode char(6) null, //单位编号
personcode char(12) null, //个人编号
operadate smalldatetime not null, //对卡的操作日期
stateflag tinyint not null, //
www.eeworm.com/read/376468/2710526
sql tolltype.sql
create table tolltype(
hoscode char(4) not null,
tollname char(10) not null, //医保中心收费项目类型名称:中药费/西药费/床位费/检查费/治疗费/特治费/特检费
wbcode char(10) null, //五笔码
pycode char(10) null, //拼音码
effectflag tiny
www.eeworm.com/read/376468/2710527
sql mcrecord.sql
create table mcrecord(
hoscode char(4) not null, //医院登记号
riceiptcode char(12) not null, //处方(住院明细)号
riceipttype tinyint not null, //对于门诊:1-处方,2-处置,3-检查,对于住院,缺省值为1,无意义
bankriceipt char(12) nu
www.eeworm.com/read/376468/2710528
sql invoice.sql
create table invoice(
flowcode char(12) not null, //流水号
orders smallint not null, //顺序号
unitcode char(6) not null, //单位编号
feedate smalldatetime not null, //缴费期限
unitpaydate smalldatetime
www.eeworm.com/read/376468/2710542
sql commarg.sql
CREATE TABLE commarg (
argname char(30),
argument char(30),
note char(60),
updateflag char(60));
INSERT INTO commarg VALUES (
'clinicstart',
'10',
'特殊慢性病自付标准(百分比,以上年度退休费为基数)',
'001100
www.eeworm.com/read/376468/2710543
sql listtable.sql
CREATE TABLE listtable (
unitcode char(6),
listmonth datetime,
flowcode char(12),
r1 float,
r2 float,
z1 decimal(16, 2),
z2 decimal(16, 2),
p1 decimal(16, 2),
p2 decimal(16, 2),
p3
www.eeworm.com/read/376468/2710544
sql unittype.sql
CREATE TABLE unittype (
name char(24),
wbcode char(10),
pycode char(10),
effectflag float);
INSERT INTO unittype VALUES (
'事业单位',
'AA',
NULL,
1);
INSERT INTO unittype VALUES (
'行政单