The power of hyphen in Solaris

I have to admit ... sometimes I make stupid mistakes ... and instead of slowing down and rethinking I just increase the tempo ... and the result could be quite messy ...


Today I fought the Essbase 11.1.3 client installation on Solaris ... It had to be performed under separate user so after sudo su -

you type su userName -

of course if you are too in a hurry you missed the hyphen !!!

So what happens you become the userName user , but ... it takes your environmental variables and the installer starts to complain about not having permissions to write on $HOME/software directories ... of course not because they belong to the superuser !!!

Anyway this one of the reasons I love Linux and Solaris ... they simply are not flexible but smash you with your own stupidity ...

when will the use of fossil fuels end ?!

question: when will the use of fossil fuels start declining ?
answer: when these guys can scale and start making profits:

www.thefutureofthings.com/news/1249/petrol-excreting-bugs.html

...www.thefutureofthings.com/news/1241/new-green-jet-fuel-x-prize.html

www.thefutureofthings.com/news/7999/solar-powered-biofuel-under-development.html

www.thefutureofthings.com/news/7934/solar-energy-produced-using-artificial-leaf.html

www.thefutureofthings.com/news/1241/new-green-jet-fuel-x-prize.html

www.thefutureofthings.com/news/9595/bacteria-turns-carbon-dioxide-into-liquid-fuel.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+tfot+%28TFOT+-+The+Future+Of+Things%29

Моите принципи

Едно е да се баеш, второ да знаеш какво искаш , трето наистина да го искаш , четвърто е да знаеш как да го направиш , пето да можеш да го направиш , шесто е наистина да го направиш , седмо да не съжаляваш че си го направил

Не си въобгъзявай. Правиж не само себе си , но и останалите на гъз.

Не лъжи – така или иначе истината излиза наяве.

Бъди горд. По-добре замълчи и не им обръщай внимание. Бъди душевно и физически изправен, но не и надменен.

Мисли тук и сега и действай според реалността, но знай че успешното бъдеще иска стратегическо планиране.

Не кради. Ако крадеш , значи не го заслужаваш.

Ако не обичаш и пазиш себе си, няма да имаш сили да обичаш и пазиш хората които обичаш около себе си.

Не е важно да спечелиш всяка една битка. Важното е да си победител във войната на живота

Когато бързаш без да мислиш и си стесиран, малките камъчета правят големи поражения

Виртуалният свят оправлява физическия, но той е нищо като му дръпнат шалтера

Не бъди по-краставичар от краставичаря. Ако няма какво да кажеш си мълчи като индианец. Като мълчиш не ги гледай във очите.

Черната овца никой не я обича както и да мечи или да се опитва да смени козината

Сдраво тяло, здрав дух. Можеш да разбереш колко е безценно здравето чак като го изгубиш.

Когато има междуособици във тима, не говори за личности а за обстоятелства и проблеми

Не се критикувай пред останалите, още по-малко не повдигай темата за твоите грешки …

Голмайсторите от чужбина ги търпят само докато правят голове, когато престанат ги ритат първи извън терена

Моите принципи

Едно е да се баеш, второ да знаеш какво искаш , трето наистина да го искаш , четвърто е да знаеш как да го направиш , пето да можеш да го направиш , шесто е наистина да го направиш , седмо да не съжаляваш че си го направил

Не си въобгъзявай. Правиж не само себе си , но и останалите на гъз.

Не лъжи – така или иначе истината излиза наяве.

Бъди горд. По-добре замълчи и не им обръщай внимание. Бъди душевно и физически изправен, но не и надменен.

Мисли тук и сега и действай според реалността, но знай че успешното бъдеще иска стратегическо планиране.

Не кради. Ако крадеш , значи не го заслужаваш.

Ако не обичаш и пазиш себе си, няма да имаш сили да обичаш и пазиш хората които обичаш около себе си.

Не е важно да спечелиш всяка една битка. Важното е да си победител във войната на живота

Когато бързаш без да мислиш и си стесиран, малките камъчета правят големи поражения

Виртуалният свят оправлява физическия, но той е нищо като му дръпнат шалтера

Не бъди по-краставичар от краставичаря. Ако няма какво да кажеш си мълчи като индианец. Като мълчиш не ги гледай във очите.

Черната овца никой не я обича както и да мечи или да се опитва да смени козината

Сдраво тяло, здрав дух. Можеш да разбереш колко е безценно здравето чак като го изгубиш.

Когато има междуособици във тима, не говори за личности а за обстоятелства и проблеми

Не се критикувай пред останалите, още по-малко не повдигай темата за твоите грешки …

Select count (TaskName) from MyTodo list

Affected rows 20 ...
Jee, I just realized how-many things I have to think of in a chaotic manner.

Now that I created a simple todo list with sorting for deadlines , priority and status for the next 3 months it looks depressing ...

Who cares ... Apparently until yesterday neither did I ...

Seriously do you think you could be good in your leading role at work without having organized yourself ... Seems unlogical to me ...

Most of the wanna be big bosses I see everyday seem to have this problem , and it is not simply stress or work pressure - it is personal disorder. Funny that IT was supposed to organize our lifes but in a way it brings more chaos and disorder

how-to get all local groups and their users on Windows

'==== START FILE \GetLocalGroupsAndUsers.vbs ==========================

' USAGE: Start - Run - type cmd.exe - go to this script folder 

' and type cscript GetLocalGroupsAndUsers.vbs > GroupsAndUsers.txt&GroupsAndUsers.txt

'PLACE HERE YOUR HOSTNAME

'

strComputer = "hostName"

Set colGroups = GetObject("WinNT://" & strComputer & "")

colGroups.Filter = Array("group")

For Each objGroup In colGroups

For Each objUser in objGroup.Members

If 1=1 Then

Wscript.Echo objGroup.Name + " --- " + objUser.name 

End If

Next

Next

'==== END FILE \GetLocalGroupsAndUsers.vbs ==========================

moite principi

	A	B
1	Важност	Принцип
2	1	Едно е да се баеш, второ да знаеш какво искаш , трето наистина да го искаш , четвърто е да знаеш как да го направиш , пето да можеш да го направиш , шесто е наистина да го направиш , седмо да не съжаляваш че си го направил
3	2	Не си въобгъзявай. Правиж не само себе си , но и останалите на гъз.
4	3	Не лъжи – така или иначе истината излиза наяве.
5	4	Бъди горд. По-добре замълчи и не им обръщай внимание. Бъди душевно и физически изправен, но не и надменен.
6	5	Мисли тук и сега и действай според реалността, но знай че успешното бъдеще иска стратегическо планиране.
7	6	Не кради. Ако крадеш , значи не го заслужаваш.
8	7	Ако не обичаш и пазиш себе си, няма да имаш сили да обичаш и пазиш хората които обичаш около себе си.
9	8	Не е важно да спечелиш всяка една битка. Важното е да си победител във войната на живота
10	9	Когато бързаш без да мислиш и си стесиран, малките камъчета правят големи поражения
11	10	Виртуалният свят оправлява физическия, но той е нищо като му дръпнат шалтера
12

how-to get a nice time in windows 7 cmd

@echo off

:: START FILE GetNiceTime.cmd ====================================================

:: HAVING THE FOLLOWING DATE TIME FORMATS time is 21:30:27,47 and date is to 20.05.2010 

:: START USAGE  ==================================================================

:: SET THE NICETIME 

:: SET NICETIME=BOO

:: CALL GetNiceTime.cmd 

:: ECHO NICETIME IS %NICETIME%

:: echo nice time is %NICETIME%

:: END USAGE  ==================================================================

echo set hhmmsss

:: this is Regional settings dependant so tweak this according your current settings

for /f "tokens=1-3 delims=,: " %%a in ('echo %time%') do set hhmmsss=%%a%%b%%c 

:: DEBUG PAUSE

ECHO hhmmsss IS %hhmmsss%

:: DEBUG PAUSE

echo %yyyymmdd%

:: this is Regional settings dependant so tweak this according your current settings

for /f "tokens=2-4 delims=. " %%D in ('echo %DATE%') do set  yyyymmdd=%%F%%E%%D

::DEBUG ECHO yyyymmdd IS %yyyymmdd%

:: DEBUG PAUSE

set NICETIME=%yyyymmdd%_%hhmmsss%

:: DEBUG PAUSE

echo THE NICETIME IS %NICETIME%

:: DEBUG PAUSE

:: =========END FILE GetNiceTime.cmd ====================================================

how-to list all local groups and users in vbs on windows server 2003

strComputer = "computerName"
Set colGroups = GetObject("WinNT://" & strComputer & "")
colGroups.Filter = Array("group")

For Each objGroup In colGroups
For Each objUser in objGroup.Members
If 1=1 Then
Wscript.Echo objGroup.Name + " --- " + objUser.name
End If
Next
Next

how-to make backups of my files in the current directory on Windows

:: check first the previous post for Getting A Nice Time in windows cmd

@ECHO OFF 

:: ==============  FILE BackUpCurrentDirFiles.cmd START =========================================================

ECHO BackUpCurrentDirFiles.cmd -- makes timestamped versions of each files in the current directory 

ECHO AND PLACES THEM INTO THE BACKUPS DIRECTORY 

ECHO CREATE THE BACKUPS FOLDER IF IT DOES NOT EXIST 

mkdir backups 

SET NICETIME=BOO

CALL GetNiceTime.cmd 

:: DEBUG PAUSE

ECHO NICETIME IS %NICETIME%

:: DEBUG PAUSE

echo nice time is %NICETIME%

::for /f "tokens=1,2 delims=." %%i in ('dir /b') do ECHO %%i.%%j

ECHO FIRST COPY THE FILES INTO THE BACKUPS FOLDER

for /f "tokens=1,2 delims=." %%i in ('dir /b /A-D') do copy "%%i.%%j" "%CD%\backups\"

:: DEBUG PAUSE
 
for /f "tokens=1,2 delims=." %%i in ('dir /b /A-D') do RENAME "%CD%\backups\%%i.%%j" "%%i%NICETIME%.%%j"

:: DEBUG PAUSE

:: ==============  FILE BackUpCurrentDirFiles.cmd END =========================================================

how-to get a nice time in windows cmd.exe

@echo off

:: START FILE GetNiceTime.cmd ====================================================

:: START USAGE  ==================================================================

::SET THE NICETIME 

:: SET NICETIME=BOO

:: CALL GetNiceTime.cmd 

:: ECHO NICETIME IS %NICETIME%

:: echo nice time is %NICETIME%

:: END USAGE  ==================================================================

echo set hhmmsss

:: this is Regional settings dependant so tweak this according your current settings

for /f "tokens=1-3 delims=:." %%a in ('echo %time%') do set hhmmsss=%%a%%b%%c 

::DEBUG ECHO hhmmsss IS %hhmmsss%

::DEBUG PAUSE

echo %yyyymmdd%

:: this is Regional settings dependant so tweak this according your current settings

for /f "tokens=1-3 delims=." %%D in ('echo %DATE%') do set  yyyymmdd=%%F%%E%%D

::DEBUG ECHO yyyymmdd IS %yyyymmdd%

::DEBUG PAUSE

set NICETIME=%yyyymmdd%_%hhmmsss%

::DEBUG echo THE NICETIME IS %NICETIME%

::DEBUG PAUSE

:: =========END FILE GetNiceTime.cmd ====================================================

how-to make backups of my files in the current directory on Windows

@ECHO OFF 
:: ==============  FILE BackUp.cmd START =========================================================

ECHO BackUp.cmd -- makes timestamped versions of each files in the current directory 
ECHO AND PLACES THEM INTO THE BACKUPS DIRECTORY 
 

ECHO CREATE THE BACKUPS FOLDER IF IT DOES NOT EXIST 
mkdir backups 

SET NICETIME=BOO
CALL GetNiceTime.cmd 
:: DEBUG PAUSE

ECHO NICETIME IS %NICETIME%
:: DEBUG PAUSE
echo nice time is %NICETIME%

::for /f "tokens=1,2 delims=." %%i in ('dir /b') do ECHO %%i.%%j
ECHO FIRST COPY THE FILES INTO THE BACKUPS FOLDER
for /f "tokens=1,2 delims=." %%i in ('dir /b /A-D') do copy %%i.%%j %CD%\backups\
:: DEBUG PAUSE

for /f "tokens=1,2 delims=." %%i in ('dir /b /A-D') do RENAME %CD%\backups\%%i.%%j "%%i%NICETIME%.%%j"
:: DEBUG PAUSE

:: ==============  FILE BackUp.cmd END =========================================================

opera 10 on N900

URL /* START wrap long lines */ white-space: pre-wrap; /* css-3 */ white-space: -moz-pre-wrap; /* Mozilla, since 1999 */ white-space: -pre-wrap; /* Opera 4-6 */ white-space: -o-pre-wrap; /* Opera 7 */ word-wrap: break-word; /* Internet Explorer 5.5+ */ /* END wrap long lines */

how-to generate sql stored procedures with bcp and stored them into separate files

URL

SET NOCOUNT ON;

DECLARE @DirForOutput NVARCHAR(300)

-- THIS IS THE DIRECTORY WHERE THE GENERATED CODE WILL BE SAVED 

SET @DirForOutput = 'D:\cas\Sql_dev\sql_dev.0.3.2.20100509\Scripts\TestDataTypes\output\StoredProcs\Insert\'

DROP TABLE #TableList 

--Grab all the functions for the current DB 

SELECT IDENTITY(INT,1,1) AS ID,

NAME

INTO #TableList

FROM sys.tables where name like 'TestDataType%'

DECLARE

@Loopid INT,

@MaxId INT

--Grab start and end values for the loop

SELECT @Loopid = 1,

@MaxId = MAX(ID)

FROM #TableList

DECLARE

@TableName VARCHAR(400) ,

@Permission VARCHAR(20),

@DataType VARCHAR(20)

--This is where the loop starts

WHILE @Loopid <= @MaxId BEGIN

--grab the function name and type

SELECT @TableName = NAME

FROM #TableList

WHERE ID = @Loopid

DECLARE @StrSqlCode1 NVARCHAR(max)

--construct the statement

-- ACTION !!! boom boom boom db.schema.procToCall format !!!

select @StrSqlCode1 = 'exec cas_dev.dbo.procUtils_GenerateInsertProc ''' + @TableName + ''''

--PRINT (@StrSqlCode1) --change PRINT to EXECUTE if you want it to run automatically

exec sp_executesql  @StrSqlCode1

declare @bcpsql varchar(8000)

-- boom boom boom check the path !!!

select @bcpsql = 'BCP "' + @StrSqlCode1+ '" queryout ' + @DirForOutput + 'procGen_' + @TableName + '_Insert.StoredProcedure.sql -c -t, -T '

--print @bcpsql

exec master..xp_cmdshell @bcpsql

--increment counter

SET @Loopid = @Loopid + 1

END

--clean up

DROP TABLE #TableList

How-to open tab in background in chrome from Google Reader

download from here the extenssion http://www.chromeextensions.org/appearance-functioning/google-reader-open-in-background-tab/

Just downloaded the newest Crome and guess what ...

It feels faster than the Opera 10.53 !!!

But , no my major browser remains Opera ... since it has the best hacker usability for now ... I wish both Opera and Chrome could become more stable ...

List of test table for each datatype in sql server 2008

-- START dbo.TestDataType_bigint.Table.sql

/****** Object:  Table [dbo].[TestDataType_bigint]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_bigint]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_bigint]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_bigint]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_bigint](

[TestDataType_bigintId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_bigint] [bigint] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_bigintId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, 

ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_bigintId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, 

ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_bigint.Table.sql

-- START dbo.TestDataType_binary.Table.sql

/****** Object:  Table [dbo].[TestDataType_binary]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_binary]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_binary]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_binary]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_binary](

[TestDataType_binaryId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_binary] [binary](1) NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_binaryId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_binaryId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_binary.Table.sql

-- START dbo.TestDataType_bit.Table.sql

/****** Object:  Table [dbo].[TestDataType_bit]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_bit]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_bit]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_bit]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_bit](

[TestDataType_bitId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_bit] [bit] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_bitId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_bitId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_bit.Table.sql

-- START dbo.TestDataType_char.Table.sql

/****** Object:  Table [dbo].[TestDataType_char]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_char]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_char]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_char]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_char](

[TestDataType_charId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_char] [char](1) NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_charId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_charId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_char.Table.sql

-- START dbo.TestDataType_datetime.Table.sql

/****** Object:  Table [dbo].[TestDataType_datetime]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_datetime]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_datetime]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_datetime]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_datetime](

[TestDataType_datetimeId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_datetime] [datetime] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_datetimeId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_datetimeId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_datetime.Table.sql

-- START dbo.TestDataType_decimal.Table.sql

/****** Object:  Table [dbo].[TestDataType_decimal]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_decimal]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_decimal]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_decimal]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_decimal](

[TestDataType_decimalId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_decimal] [decimal](18, 0) NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_decimalId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_decimalId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_decimal.Table.sql

-- START dbo.TestDataType_float.Table.sql

/****** Object:  Table [dbo].[TestDataType_float]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_float]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_float]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_float]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_float](

[TestDataType_floatId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_float] [float] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_floatId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_floatId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_float.Table.sql

-- START dbo.TestDataType_image.Table.sql

/****** Object:  Table [dbo].[TestDataType_image]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_image]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_image]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_image]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_image](

[TestDataType_imageId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_image] [image] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_imageId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_imageId] 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]

END

GO

-- END dbo.TestDataType_image.Table.sql

-- START dbo.TestDataType_int.Table.sql

/****** Object:  Table [dbo].[TestDataType_int]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_int]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_int]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_int]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_int](

[TestDataType_intId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_int] [int] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_intId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_intId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_int.Table.sql

-- START dbo.TestDataType_money.Table.sql

/****** Object:  Table [dbo].[TestDataType_money]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_money]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_money]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_money]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_money](

[TestDataType_moneyId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_money] [money] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_moneyId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_moneyId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_money.Table.sql

-- START dbo.TestDataType_nchar.Table.sql

/****** Object:  Table [dbo].[TestDataType_nchar]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_nchar]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_nchar]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_nchar]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_nchar](

[TestDataType_ncharId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_nchar] [nchar](1) NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_ncharId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_ncharId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_nchar.Table.sql

-- START dbo.TestDataType_ntext.Table.sql

/****** Object:  Table [dbo].[TestDataType_ntext]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_ntext]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_ntext]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_ntext]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_ntext](

[TestDataType_ntextId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_ntext] [ntext] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_ntextId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_ntextId] 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]

END

GO

-- END dbo.TestDataType_ntext.Table.sql

-- START dbo.TestDataType_numeric.Table.sql

/****** Object:  Table [dbo].[TestDataType_numeric]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_numeric]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_numeric]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_numeric]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_numeric](

[TestDataType_numericId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_numeric] [numeric](18, 0) NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_numericId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_numericId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_numeric.Table.sql

-- START dbo.TestDataType_nvarchar.Table.sql

/****** Object:  Table [dbo].[TestDataType_nvarchar]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_nvarchar]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_nvarchar]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_nvarchar]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_nvarchar](

[TestDataType_nvarcharId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_nvarchar] [nvarchar](1) NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_nvarcharId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_nvarcharId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_nvarchar.Table.sql

-- START dbo.TestDataType_real.Table.sql

/****** Object:  Table [dbo].[TestDataType_real]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_real]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_real]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_real]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_real](

[TestDataType_realId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_real] [real] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_realId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_realId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_real.Table.sql

-- START dbo.TestDataType_smalldatetime.Table.sql

/****** Object:  Table [dbo].[TestDataType_smalldatetime]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_smalldatetime]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_smalldatetime]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_smalldatetime]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_smalldatetime](

[TestDataType_smalldatetimeId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_smalldatetime] [smalldatetime] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_smalldatetimeId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_smalldatetimeId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_smalldatetime.Table.sql

-- START dbo.TestDataType_smallint.Table.sql

/****** Object:  Table [dbo].[TestDataType_smallint]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_smallint]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_smallint]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_smallint]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_smallint](

[TestDataType_smallintId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_smallint] [smallint] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_smallintId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_smallintId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_smallint.Table.sql

-- START dbo.TestDataType_smallmoney.Table.sql

/****** Object:  Table [dbo].[TestDataType_smallmoney]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_smallmoney]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_smallmoney]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_smallmoney]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_smallmoney](

[TestDataType_smallmoneyId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_smallmoney] [smallmoney] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_smallmoneyId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_smallmoneyId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_smallmoney.Table.sql

-- START dbo.TestDataType_sql_variant.Table.sql

/****** Object:  Table [dbo].[TestDataType_sql_variant]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_sql_variant]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_sql_variant]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_sql_variant]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_sql_variant](

[TestDataType_sql_variantId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_sql_variant] [sql_variant] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_sql_variantId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_sql_variantId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_sql_variant.Table.sql

-- START dbo.TestDataType_text.Table.sql

/****** Object:  Table [dbo].[TestDataType_text]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_text]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_text]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_text]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_text](

[TestDataType_textId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_text] [text] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_textId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_textId] 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]

END

GO

-- END dbo.TestDataType_text.Table.sql

-- START dbo.TestDataType_timestamp.Table.sql

/****** Object:  Table [dbo].[TestDataType_timestamp]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_timestamp]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_timestamp]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_timestamp]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_timestamp](

[TestDataType_timestampId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_timestamp] [timestamp] NOT NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_timestampId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_timestampId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_timestamp.Table.sql

-- START dbo.TestDataType_tinyint.Table.sql

/****** Object:  Table [dbo].[TestDataType_tinyint]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_tinyint]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_tinyint]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_tinyint]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_tinyint](

[TestDataType_tinyintId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_tinyint] [tinyint] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_tinyintId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_tinyintId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_tinyint.Table.sql

-- START dbo.TestDataType_uniqueidentifier.Table.sql

/****** Object:  Table [dbo].[TestDataType_uniqueidentifier]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_uniqueidentifier]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_uniqueidentifier]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_uniqueidentifier]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_uniqueidentifier](

[TestDataType_uniqueidentifierId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_uniqueidentifier] [uniqueidentifier] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_uniqueidentifierId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_uniqueidentifierId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_uniqueidentifier.Table.sql

-- START dbo.TestDataType_varbinary.Table.sql

/****** Object:  Table [dbo].[TestDataType_varbinary]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_varbinary]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_varbinary]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_varbinary]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_varbinary](

[TestDataType_varbinaryId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_varbinary] [varbinary](1) NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_varbinaryId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_varbinaryId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_varbinary.Table.sql

-- START dbo.TestDataType_varchar.Table.sql

/****** Object:  Table [dbo].[TestDataType_varchar]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_varchar]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_varchar]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_varchar]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_varchar](

[TestDataType_varcharId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_varchar] [varchar](1) NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_varcharId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_varcharId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_varchar.Table.sql

-- START dbo.TestDataType_xml.Table.sql

/****** Object:  Table [dbo].[TestDataType_xml]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_xml]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_xml]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_xml]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_xml](

[TestDataType_xmlId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_xml] [xml] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_xmlId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_xmlId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_xml.Table.sql

-- START list.sql

-- START dbo.TestDataType_bigint.Table.sql

/****** Object:  Table [dbo].[TestDataType_bigint]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_bigint]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_bigint]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_bigint]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_bigint](

[TestDataType_bigintId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_bigint] [bigint] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_bigintId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, 

ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_bigintId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, 

ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_bigint.Table.sql

-- START dbo.TestDataType_binary.Table.sql

/****** Object:  Table [dbo].[TestDataType_binary]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_binary]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_binary]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_binary]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_binary](

[TestDataType_binaryId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_binary] [binary](1) NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_binaryId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_binaryId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_binary.Table.sql

-- START dbo.TestDataType_bit.Table.sql

/****** Object:  Table [dbo].[TestDataType_bit]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_bit]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_bit]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_bit]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_bit](

[TestDataType_bitId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_bit] [bit] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_bitId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_bitId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_bit.Table.sql

-- START dbo.TestDataType_char.Table.sql

/****** Object:  Table [dbo].[TestDataType_char]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_char]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_char]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_char]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_char](

[TestDataType_charId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_char] [char](1) NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_charId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_charId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_char.Table.sql

-- START dbo.TestDataType_datetime.Table.sql

/****** Object:  Table [dbo].[TestDataType_datetime]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_datetime]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_datetime]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_datetime]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_datetime](

[TestDataType_datetimeId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_datetime] [datetime] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_datetimeId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_datetimeId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_datetime.Table.sql

-- START dbo.TestDataType_decimal.Table.sql

/****** Object:  Table [dbo].[TestDataType_decimal]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_decimal]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_decimal]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_decimal]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_decimal](

[TestDataType_decimalId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_decimal] [decimal](18, 0) NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_decimalId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_decimalId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_decimal.Table.sql

-- START dbo.TestDataType_float.Table.sql

/****** Object:  Table [dbo].[TestDataType_float]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_float]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_float]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_float]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_float](

[TestDataType_floatId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_float] [float] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_floatId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_floatId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_float.Table.sql

-- START dbo.TestDataType_image.Table.sql

/****** Object:  Table [dbo].[TestDataType_image]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_image]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_image]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_image]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_image](

[TestDataType_imageId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_image] [image] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_imageId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_imageId] 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]

END

GO

-- END dbo.TestDataType_image.Table.sql

-- START dbo.TestDataType_int.Table.sql

/****** Object:  Table [dbo].[TestDataType_int]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_int]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_int]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_int]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_int](

[TestDataType_intId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_int] [int] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_intId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_intId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_int.Table.sql

-- START dbo.TestDataType_money.Table.sql

/****** Object:  Table [dbo].[TestDataType_money]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_money]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_money]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_money]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_money](

[TestDataType_moneyId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_money] [money] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_moneyId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_moneyId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_money.Table.sql

-- START dbo.TestDataType_nchar.Table.sql

/****** Object:  Table [dbo].[TestDataType_nchar]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_nchar]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_nchar]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_nchar]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_nchar](

[TestDataType_ncharId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_nchar] [nchar](1) NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_ncharId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_ncharId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_nchar.Table.sql

-- START dbo.TestDataType_ntext.Table.sql

/****** Object:  Table [dbo].[TestDataType_ntext]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_ntext]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_ntext]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_ntext]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_ntext](

[TestDataType_ntextId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_ntext] [ntext] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_ntextId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_ntextId] 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]

END

GO

-- END dbo.TestDataType_ntext.Table.sql

-- START dbo.TestDataType_numeric.Table.sql

/****** Object:  Table [dbo].[TestDataType_numeric]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_numeric]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_numeric]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_numeric]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_numeric](

[TestDataType_numericId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_numeric] [numeric](18, 0) NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_numericId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_numericId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_numeric.Table.sql

-- START dbo.TestDataType_nvarchar.Table.sql

/****** Object:  Table [dbo].[TestDataType_nvarchar]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_nvarchar]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_nvarchar]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_nvarchar]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_nvarchar](

[TestDataType_nvarcharId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_nvarchar] [nvarchar](1) NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_nvarcharId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_nvarcharId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_nvarchar.Table.sql

-- START dbo.TestDataType_real.Table.sql

/****** Object:  Table [dbo].[TestDataType_real]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_real]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_real]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_real]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_real](

[TestDataType_realId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_real] [real] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_realId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_realId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_real.Table.sql

-- START dbo.TestDataType_smalldatetime.Table.sql

/****** Object:  Table [dbo].[TestDataType_smalldatetime]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_smalldatetime]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_smalldatetime]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_smalldatetime]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_smalldatetime](

[TestDataType_smalldatetimeId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_smalldatetime] [smalldatetime] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_smalldatetimeId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_smalldatetimeId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_smalldatetime.Table.sql

-- START dbo.TestDataType_smallint.Table.sql

/****** Object:  Table [dbo].[TestDataType_smallint]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_smallint]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_smallint]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_smallint]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_smallint](

[TestDataType_smallintId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_smallint] [smallint] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_smallintId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_smallintId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_smallint.Table.sql

-- START dbo.TestDataType_smallmoney.Table.sql

/****** Object:  Table [dbo].[TestDataType_smallmoney]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_smallmoney]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_smallmoney]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_smallmoney]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_smallmoney](

[TestDataType_smallmoneyId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_smallmoney] [smallmoney] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_smallmoneyId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_smallmoneyId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_smallmoney.Table.sql

-- START dbo.TestDataType_sql_variant.Table.sql

/****** Object:  Table [dbo].[TestDataType_sql_variant]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_sql_variant]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_sql_variant]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_sql_variant]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_sql_variant](

[TestDataType_sql_variantId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_sql_variant] [sql_variant] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_sql_variantId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_sql_variantId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_sql_variant.Table.sql

-- START dbo.TestDataType_text.Table.sql

/****** Object:  Table [dbo].[TestDataType_text]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_text]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_text]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_text]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_text](

[TestDataType_textId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_text] [text] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_textId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_textId] 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]

END

GO

-- END dbo.TestDataType_text.Table.sql

-- START dbo.TestDataType_timestamp.Table.sql

/****** Object:  Table [dbo].[TestDataType_timestamp]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_timestamp]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_timestamp]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_timestamp]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_timestamp](

[TestDataType_timestampId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_timestamp] [timestamp] NOT NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_timestampId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_timestampId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_timestamp.Table.sql

-- START dbo.TestDataType_tinyint.Table.sql

/****** Object:  Table [dbo].[TestDataType_tinyint]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_tinyint]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_tinyint]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_tinyint]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_tinyint](

[TestDataType_tinyintId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_tinyint] [tinyint] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_tinyintId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_tinyintId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_tinyint.Table.sql

-- START dbo.TestDataType_uniqueidentifier.Table.sql

/****** Object:  Table [dbo].[TestDataType_uniqueidentifier]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_uniqueidentifier]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_uniqueidentifier]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_uniqueidentifier]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_uniqueidentifier](

[TestDataType_uniqueidentifierId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_uniqueidentifier] [uniqueidentifier] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_uniqueidentifierId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_uniqueidentifierId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_uniqueidentifier.Table.sql

-- START dbo.TestDataType_varbinary.Table.sql

/****** Object:  Table [dbo].[TestDataType_varbinary]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_varbinary]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_varbinary]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_varbinary]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_varbinary](

[TestDataType_varbinaryId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_varbinary] [varbinary](1) NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_varbinaryId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_varbinaryId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_varbinary.Table.sql

-- START dbo.TestDataType_varchar.Table.sql

/****** Object:  Table [dbo].[TestDataType_varchar]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_varchar]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_varchar]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_varchar]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_varchar](

[TestDataType_varcharId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_varchar] [varchar](1) NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_varcharId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_varcharId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_varchar.Table.sql

-- START dbo.TestDataType_xml.Table.sql

/****** Object:  Table [dbo].[TestDataType_xml]    Script Date: 05/07/2010 21:17:29 ******/

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_xml]') AND type in (N'U'))

DROP TABLE [dbo].[TestDataType_xml]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = 

OBJECT_ID

(N'[dbo].[TestDataType_xml]') AND type in (N'U'))

BEGIN

CREATE TABLE [dbo].[TestDataType_xml](

[TestDataType_xmlId] [bigint] IDENTITY(1,1) NOT NULL,

[ColOfDataType_xml] [xml] NULL,

PRIMARY KEY CLUSTERED 

(

[TestDataType_xmlId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

[TestDataType_xmlId] ASC

)WITH (PAD_INDEX  = OFF,  STATISTICS_NORECOMPUTE  = OFF,

IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, 

ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

END

GO

-- END dbo.TestDataType_xml.Table.sql