/****** 对象: Table [dbo].[t_data_rec] 脚本日期: 05/11/2012 12:37:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[t_data_rec]( [id] [int] NOT NULL, [devname] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, [happentime] [datetime] NULL, [varname] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, [vardesc] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, [datavalue] [float] NULL, [strreserve1] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, [strreserve2] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, [strreserve3] [nvarchar](100) COLLATE Chinese_PRC_CI_AS NULL, [intreserve1] [int] NULL, [intreserve2] [int] NULL, [intreserve3] [int] NULL, CONSTRAINT [PK_t_data_rec] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY]