Help table for sql types

USE [GenApp]

GO

/****** Object:  Table [dbo].[SqlDataTypeToControlTypeConverter]    Script Date: 07/07/2009 09:36:34 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[SqlDataTypeToControlTypeConverter](

[SqlDataTypeToControlConverterId] [int] IDENTITY(1,1) NOT NULL,

[SqlDataType] [varchar](200) NOT NULL,

[ControlTypeId] [int] NULL,

[Description] [varchar](max) NULL,

CONSTRAINT [PK_SqlDataTypeToControlTypeConverter] PRIMARY KEY CLUSTERED 

(

[SqlDataTypeToControlConverterId] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING ON

GO

USE [GenApp];

SET NOCOUNT ON;

SET XACT_ABORT ON;

GO

SET IDENTITY_INSERT [dbo].[SqlDataTypeToControlTypeConverter] ON;

BEGIN TRANSACTION;

INSERT INTO [dbo].[SqlDataTypeToControlTypeConverter]([SqlDataTypeToControlConverterId], [SqlDataType], [ControlTypeId], [Description])

SELECT 1, N'bigint', 4, NULL UNION ALL

SELECT 2, N'numeric', 4, NULL UNION ALL

SELECT 3, N'bit', 2, NULL UNION ALL

SELECT 4, N'smallint', 4, NULL UNION ALL

SELECT 5, N'decimal', 4, NULL UNION ALL

SELECT 6, N'smallmoney', 4, NULL UNION ALL

SELECT 7, N'int', 4, NULL UNION ALL

SELECT 8, N'tinyint', 4, NULL UNION ALL

SELECT 9, N'money', 4, NULL UNION ALL

SELECT 10, N'float', 4, NULL UNION ALL

SELECT 11, N'real', 4, NULL UNION ALL

SELECT 12, N'date', 5, NULL UNION ALL

SELECT 13, N'datetimeoffset', 5, NULL UNION ALL

SELECT 14, N'datetime2', 5, NULL UNION ALL

SELECT 15, N'smalldatetime', 5, NULL UNION ALL

SELECT 16, N'datetime', 5, NULL UNION ALL

SELECT 17, N'time', 5, NULL UNION ALL

SELECT 18, N'char', 4, NULL UNION ALL

SELECT 19, N'varchar', 4, NULL UNION ALL

SELECT 20, N'text', 3, NULL UNION ALL

SELECT 21, N'nchar', 4, NULL UNION ALL

SELECT 22, N'nvarchar', 4, NULL UNION ALL

SELECT 23, N'ntext', 4, NULL UNION ALL

SELECT 24, N'binary', 4, NULL UNION ALL

SELECT 25, N'varbinary', 6, NULL UNION ALL

SELECT 26, N'image', 7, NULL UNION ALL

SELECT 27, N'cursor', 8, NULL UNION ALL

SELECT 28, N'timestamp', 5, NULL UNION ALL

SELECT 29, N'hierarchyid', 8, NULL UNION ALL

SELECT 30, N'uniqueidentifier', 8, NULL UNION ALL

SELECT 31, N'sql_variant', 8, NULL UNION ALL

SELECT 32, N'xml', 3, NULL

COMMIT;

RAISERROR (N'[dbo].[SqlDataTypeToControlTypeConverter]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;

GO

SET IDENTITY_INSERT [dbo].[SqlDataTypeToControlTypeConverter] OFF;