代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/466504/7037999
sql getstssum.sql
USE MIS
GO
CREATE FUNCTION GetStsSum(@nEmpId int,@ItemId int,@iMonth int)
RETURNS decimal(15,2) AS
BEGIN
DECLARE @ItemValue decimal(15,2)
--从表SalaryStatistics中提取指定员工、指定月份、指定项目编号的工资项目数值
SET
www.eeworm.com/read/466504/7038000
sql deptrans.sql
USE Mis
GO
CREATE TABLE [DepTrans] (
[TrId] [int] IDENTITY (1, 1) NOT NULL ,
[EmpId] [int] NULL ,
[OrgDepId] [int] NULL ,
[NewDepId] [int] NULL ,
[Title] [varchar] (50) COLLATE Chinese_PRC
www.eeworm.com/read/466504/7038001
sql departments.sql
USE Mis
GO
CREATE TABLE [Departments] (
[DepId] [int] NOT NULL ,
[DepName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[UpperId] [int] NOT NULL ,
CONSTRAINT [PK_Departments] PRIMARY
www.eeworm.com/read/466504/7038002
sql getitemvalue.sql
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GetItemValue]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[GetItemValue]
GO
SET QUOTED_IDENTIFIER ON
www.eeworm.com/read/466504/7038003
sql taxrate.sql
USE Mis
GO
CREATE TABLE [TaxRate] (
[Id] [int] IDENTITY (1, 1) NOT NULL ,
[LowerLimit] [int] NULL ,
[UpperLimit] [int] NULL ,
[Rate] [int] NULL ,
[Deduct] [int] NULL
) ON [PRIMARY]
GO
www.eeworm.com/read/466504/7038004
sql salaryitem.sql
USE Mis
GO
CREATE TABLE [SalaryItem] (
[ItemId] [int] IDENTITY (1, 1) NOT NULL ,
[ItemName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ItemType] [tinyint] NULL ,
[ItemSum] [decimal](15
www.eeworm.com/read/466504/7038005
sql evaluation.sql
USE Mis
GO
CREATE TABLE [Evaluation] (
[EvaId] [int] IDENTITY (1, 1) NOT NULL ,
[EmpId] [int] NULL ,
[EvaDate] [datetime] NULL ,
[Subject] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
www.eeworm.com/read/466120/7038732
sql office.sql
www.eeworm.com/read/466125/7039287
sql shop.sql
-----------------------------建库shop----------------------------------
use master
create database shop
go
use shop
go
-----------------------------删除各主表之间的关系----------------------------------
www.eeworm.com/read/466091/7044435
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.