|
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[testdata]
(
[rowID] [int] IDENTITY(1,1) NOT NULL,
[byte1] [tinyint] NULL,
[short1] [smallint] NULL,
[int1] [int] NULL,
[long1] [bigint] NULL,
[float1] [real] NULL,
[double1] [float] NULL,
[decimal1] [decimal](18, 8) NULL,
[money1] [money] NULL,
[string1] [varchar](max) NULL,
[binary1] [varbinary](max) NULL,
[image1] [image] NULL,
[bool1] [bit] NULL,
[datetime1] [datetime] NULL,
[guid1] [uniqueidentifier] NULL,
PRIMARY KEY CLUSTERED
(
[rowID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.