USE [haitest]
GO
/****** 对象: Table [dbo].[haiTable] 脚本日期: 03/13/2010 20:10:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[haiTable](
[buy_original_ticket] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[buy_id] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[buy_number] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[buy_type_large] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[buy_type_sub] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[buy_multi] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[buy_money] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ticket_id] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[lottery_name] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[user_random] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[md5_code] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[sale_point] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[lottery_peroid] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[award_time] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[lottery_multi] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[lottery_money] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ticket_time] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[lottery_type] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[lottery_number_1] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
--将表数据生成SQL脚本的存储过程
......
