SQL数据库,创建表的问题,非常着急 sql数据库多表级联问题 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 请问这是SQL Server的语法吗? 我有TestOne(字段DocEntry,Memo),TestOneLine(字段DocEntry,LineNum,LineMemo),TestOneLine1(字段DocEntry,LineNum,LineNum1,LineMemo)其中TestOneLine是TestOne的子表其中TestOneLine1又是TestOneLine的子表该怎么写sql语句,创建表呢? 不知道你表中字段的数据类型是什么,另这3张表通过什么来关联的。下面的sql只是一个例子。create table TestOne(DocEntry int,Memo varchar(50),constraint PK_Testone primary key(DocEntry))create table TestOneLine(DocEntry int,LineNum int,LineMemo varchar(50)constraint PK_TestOneLine primary key(DocEntry))create table TestOneLine1(DocEntry int,LineNum int,LineNum1 int,LineMemo varchar(50))alter table TestOneLine add constraint FK_TestOneLine foreign key(DocEntry) references TestOne(DocEntry)alter table TestOneLine1 add constraint FK_TestOneLine1 foreign key(DocEntry) references TestOneLine(DocEntry) 说的明白一点,我举一些数据给你们看下主表TestOne,数据为:DocEntry:1,Memo:备注;子表TestOneLine 数据为:第一行:DocEntry:1,LineNum:0,LineMemo:备注1;第二行:DocEntry:1,LineNum:1,LineMemo:备注2;第三行:DocEntry:1,LineNum:2,LineMemo:备注3;子表的子表TestOneLine1数据为:第一行:DocEntry:1,LineNum:0,LineNum1:0,LineMemo:备注1;第二行:DocEntry:1,LineNum:0,LineNum1:1,LineMemo:备注2;第三行:DocEntry:1,LineNum:0,LineNum1:2,LineMemo:备注3;第四行:DocEntry:1,LineNum:1,LineNum1:0,LineMemo:备注4;第五行:DocEntry:1,LineNum:1,LineNum1:1,LineMemo:备注5;第六行:DocEntry:1,LineNum:2,LineNum1:0,LineMemo:备注6;我要保存的时候,后台是存这些数据的,请问怎么写SQL 试一下下面的sqlcreate table TestOne( DocEntry int, Memo nvarchar(50), constraint PK_Testone primary key(DocEntry) ) create table TestOneLine ( DocEntry int, LineNum int, LineMemo nvarchar(50), constraint PK_TestOneLine primary key(DocEntry,LineNum)) create table TestOneLine1 ( DocEntry int, LineNum int, LineNum1 int, LineMemo nvarchar(50) ) alter table TestOneLine add constraint FK_TestOneLine foreign key(DocEntry) references TestOne(DocEntry) alter table TestOneLine1 add constraint FK_TestOneLine1 foreign key(DocEntry,LineNum) references TestOneLine(DocEntry,LineNum)insert into TestOne values(1,'备注')insert into TestOneLine values(1,0,'备注1') insert into TestOneLine values(1,1,'备注2') insert into TestOneLine values(1,2,'备注3') insert into TestOneLine1 values(1,0,0,'备注1') insert into TestOneLine1 values(1,0,1,'备注2') insert into TestOneLine1 values(1,0,2,'备注3') insert into TestOneLine1 values(1,1,0,'备注4') insert into TestOneLine1 values(1,1,1,'备注5') insert into TestOneLine1 values(1,2,0,'备注6') 帮俺写个like查询呗 全文索引---如何才能让slq2005的全文索引搜索功能更合理一点? 【求助】这句总是提示语法错误,很简单的,麻烦看看。 SQL中,将一个表的某几个字段数据导入另一个表中用触发器怎么实现 如何调用输入的日期 订阅与事务 数据分步开发,问题。 高手请进:请教一条sql语句 希望大家介绍些关于VB与SQL相结合的书,帮助我接触一下实际的数据库应用。 怎样锁住Select的行,让其他程序读不到 查询结果分类问题,SQL SERVER2000 如何按照时间段来汇总数据
DocEntry int,
Memo varchar(50),
constraint PK_Testone primary key(DocEntry)
)
create table TestOneLine
(
DocEntry int,
LineNum int,
LineMemo varchar(50)
constraint PK_TestOneLine primary key(DocEntry)
)
create table TestOneLine1
(
DocEntry int,
LineNum int,
LineNum1 int,
LineMemo varchar(50)
)
alter table TestOneLine add constraint FK_TestOneLine foreign key(DocEntry) references TestOne(DocEntry)
alter table TestOneLine1 add constraint FK_TestOneLine1 foreign key(DocEntry) references TestOneLine(DocEntry)
主表TestOne,数据为:DocEntry:1,Memo:备注;子表TestOneLine 数据为:
第一行:DocEntry:1,LineNum:0,LineMemo:备注1;
第二行:DocEntry:1,LineNum:1,LineMemo:备注2;
第三行:DocEntry:1,LineNum:2,LineMemo:备注3;子表的子表TestOneLine1数据为:
第一行:DocEntry:1,LineNum:0,LineNum1:0,LineMemo:备注1;
第二行:DocEntry:1,LineNum:0,LineNum1:1,LineMemo:备注2;
第三行:DocEntry:1,LineNum:0,LineNum1:2,LineMemo:备注3;
第四行:DocEntry:1,LineNum:1,LineNum1:0,LineMemo:备注4;
第五行:DocEntry:1,LineNum:1,LineNum1:1,LineMemo:备注5;
第六行:DocEntry:1,LineNum:2,LineNum1:0,LineMemo:备注6;我要保存的时候,后台是存这些数据的,请问怎么写SQL
(
DocEntry int,
Memo nvarchar(50),
constraint PK_Testone primary key(DocEntry)
)
create table TestOneLine
(
DocEntry int,
LineNum int,
LineMemo nvarchar(50),
constraint PK_TestOneLine primary key(DocEntry,LineNum)
)
create table TestOneLine1
(
DocEntry int,
LineNum int,
LineNum1 int,
LineMemo nvarchar(50)
)
alter table TestOneLine add constraint FK_TestOneLine foreign key(DocEntry) references TestOne(DocEntry)
alter table TestOneLine1 add constraint FK_TestOneLine1 foreign key(DocEntry,LineNum) references TestOneLine(DocEntry,LineNum)insert into TestOne values(1,'备注')insert into TestOneLine values(1,0,'备注1')
insert into TestOneLine values(1,1,'备注2')
insert into TestOneLine values(1,2,'备注3') insert into TestOneLine1 values(1,0,0,'备注1')
insert into TestOneLine1 values(1,0,1,'备注2')
insert into TestOneLine1 values(1,0,2,'备注3')
insert into TestOneLine1 values(1,1,0,'备注4')
insert into TestOneLine1 values(1,1,1,'备注5')
insert into TestOneLine1 values(1,2,0,'备注6')