代码搜索：Sql
找到约 10,000 项符合「Sql」的源代码
代码结果 10,000
www.eeworm.com/read/367874/9725122
sql personnel.sql
www.eeworm.com/read/171984/9727822
sql createclassview.sql
create view classView1(学籍号,课程,成绩)
as
select score.学籍号,score.课程,score.成绩
from class,score
where class.班级='20031371' and class.学籍号=score.学籍号
go
create view classView2(学籍号,课程,成绩)
as
select score.
www.eeworm.com/read/171984/9727824
sql createtable.sql
use
SMIS
go
create table student(
学籍号 nvarchar(10) not null primary key,
姓名 nvarchar(8) not null,
性别 nvarchar(2) default '男' check(性别 in('男','女')),
出生年月 nvarchar(7) null
)
go
create
www.eeworm.com/read/171984/9727825
sql createcourceview.sql
create view courseView1(课程,人数)
as
select 课程,count(*) as 人数
from classView1
group by 课程
go
create view courseView2(课程,人数)
as
select 课程,count(*) as 人数
from classView2
group by 课程
go
cr
www.eeworm.com/read/367390/9752764
sql chat.sql
www.eeworm.com/read/171458/9753389
sql chat.sql
www.eeworm.com/read/367283/9759901
sql myoffice.sql
if exists(select * from sysdatabases where name = 'MyOffice')
drop database MyOffice
go
create database MyOffice
on
(
name = 'MyOffice_data',
filename = 'e:\sql\MyOffice.mdf',
size = 5,
m
www.eeworm.com/read/171182/9767930
sql books.sql
CREATE TABLE books
(id VARCHAR(8)
PRIMARY KEY,
name VARCHAR(24),
title VARCHAR(96),
price FLOAT,
yr INT,
description VARCHAR(30),
saleAmount INT) default charset=gbk;
INSERT INTO books VA
www.eeworm.com/read/171173/9768096