如何使用SQL Server高级数据表提示

IF OBJECT_ID('SalesHistory')>0      

DROP TABLE SalesHistory;

GO

CREATE TABLE [dbo].[SalesHistory]

(      

      [SaleID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,      

      [Product] [char](150) NULL,      

            [SaleDate] [datetime] NULL,      

            [SalePrice] [money] NULL

)

GO

DECLARE @i SMALLINT

SET @i = 1

WHILE (@i <=100)

BEGIN                  

      INSERT INTO SalesHistory               

      (Product, SaleDate, SalePrice)                  

      VALUES      

      ('Computer', DATEADD(mm, @i, '3/11/1919'), DATEPART(ms, GETDATE()) + (@i + 57))      

      INSERT INTO SalesHistory                

      (Product, SaleDate, SalePrice)      

      VALUES             

      ('BigScreen', DATEADD(mm, @i, '3/11/1927'), DATEPART(ms, GETDATE()) + (@i + 13))                  

      INSERT INTO SalesHistory                  

      (Product, SaleDate, SalePrice)          

      VALUES            

      ('PoolTable', DATEADD(mm, @i, '3/11/1908'), DATEPART(ms, GETDATE()) + (@i + 29))                  

      SET @i = @i + 1

END

GO