【SQL开源代码栏目提醒】:以下是网学会员为您推荐的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, 2) NULL ,
[Formula] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
[IsVisible] [tinyint] NULL ,
[Operation] [tinyint] NULL
) ON [PRIMARY]
GO
INSERT INTO SalaryItem Values ('基本工资',0,0,'',1,0)
GO