Using sql server 2012 I created a user type for each base type.  

Then created a table with the user defined types.

Then inserted data into the table.

Then selected * from the table.

All came back fine.

 

SQL Server 2012

host 10.168.11.80:1433

login: sa / ******

database: NORTHWIND

 

CREATE TYPE [dbo].[ivan_bigint] FROM bigint NOT NULL

CREATE TYPE [dbo].[ivan_binaryOne] FROM binary(1) NOT NULL

CREATE TYPE [dbo].[ivan_bit] FROM bit NOT NULL

CREATE TYPE [dbo].[ivan_charFive] FROM char(5) NOT NULL

CREATE TYPE [dbo].[ivan_date] FROM date NOT NULL

CREATE TYPE [dbo].[ivan_datetime] FROM datetime NOT NULL

CREATE TYPE [dbo].[ivan_datetime2] FROM datetime2 NOT NULL

CREATE TYPE [dbo].[ivan_datetimeoffset] FROM datetimeoffset

CREATE TYPE [dbo].[ivan_decimalFifteenByFive] FROM decimal(15,5)

CREATE TYPE [dbo].[ivan_float] FROM float

CREATE TYPE [dbo].[ivan_image] FROM image

CREATE TYPE [dbo].[ivan_int] FROM int

CREATE TYPE [dbo].[ivan_money] FROM money

CREATE TYPE [dbo].[ivan_ncharFive] FROM nchar(5)

CREATE TYPE [dbo].[ivan_ntext] FROM ntext

CREATE TYPE [dbo].[ivan_numericFifteenByFive] FROM numeric(15,5)

CREATE TYPE [dbo].[ivan_nvarcharFive] FROM nvarchar(5)

CREATE TYPE [dbo].[ivan_smalldatetime] FROM smalldatetime

CREATE TYPE [dbo].[ivan_smallint] FROM smallint

CREATE TYPE [dbo].[ivan_smallmoney] FROM smallmoney

CREATE TYPE [dbo].[ivan_sql_variant] FROM sql_variant

CREATE TYPE [dbo].[ivan_text] FROM text

CREATE TYPE [dbo].[ivan_time] FROM time

CREATE TYPE [dbo].[ivan_tinyint] FROM tinyint

CREATE TYPE [dbo].[ivan_uniqueidentifier] FROM uniqueidentifier

CREATE TYPE [dbo].[ivan_varbinaryOne] FROM varbinary(1)

CREATE TYPE [dbo].[ivan_varcharTwentyFive] FROM varchar(25)

 

CREATE TABLE [dbo].[userdatatypes] (

[COL_ivan_bigint]                   [dbo].[ivan_bigint],

[COL_ivan_binaryOne]                [dbo].[ivan_binaryOne],

[COL_ivan_bit]                      [dbo].[ivan_bit],

[COL_ivan_charFive]                 [dbo].[ivan_charFive],

[COL_ivan_date]                     [dbo].[ivan_date],

[COL_ivan_datetime]                 [dbo].[ivan_datetime],

[COL_ivan_datetime2]                [dbo].[ivan_datetime2],

[COL_ivan_datetimeoffset]           [dbo].[ivan_datetimeoffset],

[COL_ivan_decimalFifteenByFive]   [dbo].[ivan_decimalFifteenByFive],

[COL_ivan_float]                    [dbo].[ivan_float],

[COL_ivan_image]                    [dbo].[ivan_image],

[COL_ivan_int]                      [dbo].[ivan_int],

[COL_ivan_money]                    [dbo].[ivan_money],

[COL_ivan_ncharFive]                [dbo].[ivan_ncharFive],

[COL_ivan_ntext]                    [dbo].[ivan_ntext],

[COL_ivan_numericFifteenByFive]   [dbo].[ivan_numericFifteenByFive],

[COL_ivan_nvarcharFive]             [dbo].[ivan_nvarcharFive],

[COL_ivan_smalldatetime]            [dbo].[ivan_smalldatetime],

[COL_ivan_smallint]                 [dbo].[ivan_smallint],

[COL_ivan_smallmoney]               [dbo].[ivan_smallmoney],

[COL_ivan_sql_variant]              [dbo].[ivan_sql_variant],

[COL_ivan_text]                     [dbo].[ivan_text],

[COL_ivan_time]                     [dbo].[ivan_time],

[COL_ivan_tinyint]                  [dbo].[ivan_tinyint],

[COL_ivan_uniqueidentifier]         [dbo].[ivan_uniqueidentifier],

[COL_ivan_varbinaryOne]             [dbo].[ivan_varbinaryOne],

[COL_ivan_varcharTwentyFive]        [dbo].[ivan_varcharTwentyFive] )

 

INSERT INTO [dbo].[userdatatypes] ([COL_ivan_bigint],[COL_ivan_binaryOne],[COL_ivan_bit],[COL_ivan_charFive],[COL_ivan_date],[COL_ivan_datetime],[COL_ivan_datetime2], [COL_ivan_decimalFifteenByFive], [COL_ivan_float], [COL_ivan_int], [COL_ivan_money], [COL_ivan_ncharFive], [COL_ivan_ntext], [COL_ivan_numericFifteenByFive], [COL_ivan_nvarcharFive], [COL_ivan_smalldatetime], [COL_ivan_smallint], [COL_ivan_smallmoney],[COL_ivan_text], [COL_ivan_time], [COL_ivan_tinyint], [COL_ivan_varbinaryOne], [COL_ivan_varcharTwentyFive]) VALUES (112123, 1, 0x1, 'char5', getdate(), getdate(), getdate(), 123123.12312, 34.3434, 123123, '$1,245.45', 'nchr5', 'ntext', 444555.555, 'nchr5', getdate(), 123, '$123.34', 'text', getdate(), 3, 0x1, 'varchar of 25 length')

 

select * from  [dbo].[userdatatypes]