代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/210343/15201132
sql matchrecord.sql
/*
//小组赛记录表（组别，球队1，球队2，场次，比赛时间，队1进球数，队2进球数）
//创建赛程安排及战况记录表
CREATE TABLE MatchRecord
(
group1 nchar(10),
team1 nchar(20) NOT NULL,
team2 nchar(20) NOT NULL,
www.eeworm.com/read/210209/15204411
sql message.sql
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[message]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[message]
GO
CREATE TABLE [dbo].[message] (
[name]
www.eeworm.com/read/210106/15206464
sql personnel.sql
www.eeworm.com/read/209923/15211765
sql courses.sql
USE VirtualTeacher
GO
CREATE TABLE Courses
(Course_ID int PRIMARY KEY IDENTITY,
Course_Name varchar(40) NOT NULL,
Course_Type int NULL
)
GO
www.eeworm.com/read/209923/15211766
sql passages.sql
USE VirtualTeacher
GO
CREATE TABLE Passages
(Pas_ID int PRIMARY KEY IDENTITY,
Pas_Name varchar(100) NOT NULL,
Course_ID int,
Words ntext
)
GO
www.eeworm.com/read/209923/15211767
sql paints.sql
USE VirtualTeacher
GO
CREATE TABLE Paints
(Pic_ID int PRIMARY KEY IDENTITY,
Pic_Name varchar(100) NOT NULL,
Course_ID int,
Pic image
)
GO
www.eeworm.com/read/209923/15211768
sql virtualteacher.sql
CREATE DATABASE VirtualTeacher
ON
( NAME='VirtualTeacher_data',
FILENAME='E:\Program Files\Microsoft SQL Server\MSSQL\Data\VIRTEACHER.mdf',
SIZE=5MB,
MAXSIZE=UNLIMITED,
www.eeworm.com/read/209923/15211769
sql users.sql
USE VirtualTeacher
GO
CREATE TABLE Users
(UserName varchar(40) PRIMARY KEY,
Pwd varchar(10) NOT NULL
)
GO
INSERT INTO Users Values('Admin','888888')
GO
www.eeworm.com/read/209583/15216998
sql trigger.sql
drop trigger stu_hotel_delete
create trigger stu_hotel_insert1 on stu_hotel
for insert
as
update hotel_information set hotel_actual_stu=hotel_actual_stu+1
from hotel_information,inserted
where
www.eeworm.com/read/209534/15217811