代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/420722/2065466
sql employees.sql
USE HR
GO
CREATE TABLE Employees
(Emp_Id int PRIMARY KEY IDENTITY,
Emp_NAME varchar(50) NOT NULL,
Photo image,
Sex char(2),
Nationality varchar(40),
Birth varchar(20),
www.eeworm.com/read/420722/2065467
sql departments.sql
USE HR
GO
CREATE TABLE Departments
(Dep_id int PRIMARY KEY IDENTITY,
Dep_name varchar(40) NOT NULL,
Describe varchar(400),
UpperId int NOT NULL
)
GO
www.eeworm.com/read/420722/2065468
sql hr.sql
USE master
GO
CREATE DATABASE HR
GO
USE HR
GO
CREATE TABLE Checkin
(CheckDate char(10) NOT NULL,
Emp_Id int NOT NULL,
qqDays decimal(4,1),
ccDays decimal(4,1),
bjDays d
www.eeworm.com/read/420722/2065470
sql users.sql
USE HR
GO
CREATE TABLE Users
(UserName varchar(40) PRIMARY KEY,
Pwd varchar(40) NOT NULL,
User_Type tinyint NOT NULL
)
GO
INSERT INTO Users Values('Admin', '888888', 1)
GO
www.eeworm.com/read/420722/2065471
sql evaluation.sql
USE HR
GO
CREATE TABLE Evaluation
(EvaMonth char(10) NOT NULL,
Emp_Id int NOT NULL,
ztEva varchar(200),
jlReason varchar(200),
jlAmount smallint,
cfReason varchar(200),
www.eeworm.com/read/418734/2084764
sql javaicq.sql
--创建javaicq数据库
CREATE database javaicq
use javaicq
--创建 icq 表,以下创建的表都不设关键字,默认都为空
create table icq
( Icqno int, /*用户的号码 */
Nickname Char (10), /*用户的呢称*/
Password Char(10),
www.eeworm.com/read/418191/2091970
sql db.sql
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[H_BLOG]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[H_BLOG]
GO
if exists (select * from dbo.sysobjects where
www.eeworm.com/read/416886/2105715
sql company.sql
/* 创建数据库 company */
drop database company
create database company
/* 创建数据表 MESSAGE */
DROP TABLE [MESSAGE]
CREATE TABLE [MESSAGE] ( [messageID] [int] IDENTITY (1, 1) NOT