📄 zjlshtab.txt
字号:
if exists (select * from sysobjects where id = object_id(N'[dbo].[zjlshtab]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[zjlshtab]
GO
CREATE TABLE [dbo].[zjlshtab] (
[izCode] [int] IDENTITY (1, 1) NOT NULL ,
[ijcode] [int] NULL ,
[igoods] [int] NULL ,
[Msum] [money] NOT NULL ,
[Mcashsum] [money] NOT NULL ,
[Mbillsum] [money] NOT NULL ,
[Mcardsum] [money] NOT NULL ,
[mshopsum] [money] NOT NULL ,
[mhungsum] [money] NOT NULL ,
[Mothsum] [money] NOT NULL ,
[Isource] [int] NOT NULL ,
[Caim] [char] (10) NOT NULL ,
[Ireason] [tinyint] NOT NULL ,
[Iinhand] [tinyint] NOT NULL ,
[pzid] [int] NULL ,
[Cpname] [char] (10) NOT NULL ,
[Dptime] [datetime] NOT NULL ,
[Crname] [varchar] (10) NOT NULL ,
[Drtime] [datetime] NOT NULL ,
[Cmemo] [char] (100) NULL
) ON [PRIMARY]
GO
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -