Search This Blog

2010-05-31

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 ...

2010-05-29

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

2010-05-27

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

Едно е да се баеш, второ да знаеш какво искаш , трето наистина да го искаш , четвърто е да знаеш как да го направиш , пето да можеш да го направиш , шесто е наистина да го направиш , седмо да не съжаляваш че си го направил
Не си въобгъзявай. Правиж не само себе си , но и останалите на гъз.
Не лъжи – така или иначе истината излиза наяве.
Бъди горд. По-добре замълчи и не им обръщай внимание. Бъди душевно и физически изправен, но не и надменен.
Мисли тук и сега и действай според реалността, но знай че успешното бъдеще иска стратегическо планиране.
Не кради. Ако крадеш , значи не го заслужаваш.
Ако не обичаш и пазиш себе си, няма да имаш сили да обичаш и пазиш хората които обичаш около себе си.
Не е важно да спечелиш всяка една битка. Важното е да си победител във войната на живота
Когато бързаш без да мислиш и си стесиран, малките камъчета правят големи поражения
Виртуалният свят оправлява физическия, но той е нищо като му дръпнат шалтера
Не бъди по-краставичар от краставичаря. Ако няма какво да кажеш си мълчи като индианец. Като мълчиш не ги гледай във очите.
Черната овца никой не я обича както и да мечи или да се опитва да смени козината
Сдраво тяло, здрав дух. Можеш да разбереш колко е безценно здравето чак като го изгубиш.
Когато има междуособици във тима, не говори за личности а за обстоятелства и проблеми
Не се критикувай пред останалите, още по-малко не повдигай темата за твоите грешки …
Голмайсторите от чужбина ги търпят само докато правят голове, когато престанат ги ритат първи извън терена


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

Едно е да се баеш, второ да знаеш какво искаш , трето наистина да го искаш , четвърто е да знаеш как да го направиш , пето да можеш да го направиш , шесто е наистина да го направиш , седмо да не съжаляваш че си го направил
Не си въобгъзявай. Правиж не само себе си , но и останалите на гъз.
Не лъжи – така или иначе истината излиза наяве.
Бъди горд. По-добре замълчи и не им обръщай внимание. Бъди душевно и физически изправен, но не и надменен.
Мисли тук и сега и действай според реалността, но знай че успешното бъдеще иска стратегическо планиране.
Не кради. Ако крадеш , значи не го заслужаваш.
Ако не обичаш и пазиш себе си, няма да имаш сили да обичаш и пазиш хората които обичаш около себе си.
Не е важно да спечелиш всяка една битка. Важното е да си победител във войната на живота
Когато бързаш без да мислиш и си стесиран, малките камъчета правят големи поражения
Виртуалният свят оправлява физическия, но той е нищо като му дръпнат шалтера
Не бъди по-краставичар от краставичаря. Ако няма какво да кажеш си мълчи като индианец. Като мълчиш не ги гледай във очите.
Черната овца никой не я обича както и да мечи или да се опитва да смени козината
Сдраво тяло, здрав дух. Можеш да разбереш колко е безценно здравето чак като го изгубиш.
Когато има междуособици във тима, не говори за личности а за обстоятелства и проблеми
Не се критикувай пред останалите, още по-малко не повдигай темата за твоите грешки …

2010-05-21

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

2010-05-20

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

2010-05-19

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 =========================================================

2010-05-12

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 */

2010-05-09

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/

2010-05-08

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 ...

2010-05-07

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

Labels

perl (41) Cheat Sheet (25) how-to (24) windows (14) sql server 2008 (13) linux (12) oracle (12) sql (12) Unix (11) cmd windows batch (10) mssql (10) cmd (9) script (9) textpad (9) netezza (8) sql server 2005 (8) cygwin (7) meta data mssql (7) metadata (7) bash (6) code generation (6) Informatica (5) cheatsheet (5) energy (5) tsql (5) utilities (5) excel (4) future (4) generic (4) git cheat sheet (4) html (4) perl modules (4) programs (4) settings (4) sh (4) shortcuts (4) поуки (4) принципи (4) Focus Fusion (3) Solaris (3) cool programs (3) development (3) economy (3) example (3) freeware (3) fusion (3) logging (3) morphus (3) mssql 2005 (3) nuclear (3) nz (3) parse (3) python (3) sftp (3) sofware development (3) source (3) sqlplus (3) table (3) vim (3) .Net (2) C# (2) China (2) GUI (2) Google (2) GoogleCL (2) Solaris Unix (2) architecture (2) ascii (2) awk (2) batch (2) cas (2) chrome extensions (2) code2html (2) columns (2) configuration (2) conversion (2) duplicates (2) excel shortcuts (2) export (2) file (2) free programs (2) informatica sql repository (2) linux cheat sheet (2) mssql 2008 (2) mysql (2) next big future (2) nsis (2) nz netezza cheat sheet (2) nzsql (2) ora (2) prediction (2) publish (2) release management (2) report (2) security (2) single-click (2) sqlserver 2005 (2) sqlserver 2008 (2) src (2) ssh (2) template (2) tools (2) vba (2) video (2) xlt (2) xml (2) youtube videos (2) *nix (1) .vimrc (1) .virmrc vim settings configs (1) BSD license (1) Bulgaria (1) Dallas (1) Database role (1) Dense plasma focus (1) Deployment (1) ERP (1) ExcelToHtml (1) GD (1) GDP (1) HP-UX (1) Hosting (1) IDEA (1) INC (1) IT general (1) ITIL management bullshit-management (1) IZarc (1) Java Web Start (1) JavaScript anchor html jquery (1) Khan Academy (1) LINUX UNIX BASH AND CYGWIN TIPS AND TRICKS (1) Linux Unix rpm cpio build install configure (1) Linux git source build .configure make (1) ListBox (1) MIT HYDROGEN VIRUS (1) OO (1) Obama (1) PowerShell (1) Run-time (1) SDL (1) SIWA (1) SOX (1) Scala (1) Services (1) Stacks (1) SubSonic (1) TED (1) abstractions (1) ansible hosts linux bash (1) ansible linux deployment how-to (1) ansible yum pip python (1) apache (1) apache 2.2 (1) application life cycle (1) architecture input output (1) archive (1) arguments (1) avatar (1) aws cheat sheet cli (1) aws cli (1) aws cli amazon cheat sheet (1) aws elb (1) backup (1) bash Linux open-ssh ssh ssh_server ssh_client public-private key authentication (1) bash perl search and replace (1) bash stub (1) bin (1) biofuels (1) biology (1) books (1) browser (1) bubblesort (1) bugs (1) build (1) byte (1) cas_sql_dev (1) chennai (1) chrome (1) class (1) claut (1) cmdow (1) code generation sqlserver (1) command (1) command line (1) conf (1) confluence (1) console (1) convert (1) cool programs windows free freeware (1) copy paste (1) copy-paste (1) csv (1) ctags (1) current local time (1) cygwin X11 port-forwarding mintty xclock Linux Unix X (1) cygwin bash how-to tips_n_tricks (1) cygwin conf how-to (1) data (1) data types (1) db2 cheat sheet (1) db2 starter ibm bash Linux (1) debt (1) diagram (1) dictionaries (1) digital (1) disk (1) disk space (1) documentation (1) dos (1) dubai (1) e-cars (1) electric cars (1) electricity (1) emulate (1) errors (1) exponents (1) export workflow (1) extract (1) fast export (1) fexp (1) file extension (1) file permissions (1) findtag (1) firewall (1) for loop (1) freaky (1) functions (1) fusion research (1) german (1) git gitlab issues handling system (1) google cli (1) google code (1) google command line interface (1) gpg (1) ha (1) head (1) helsinki (1) history (1) hop or flop (1) host-independant (1) how-to Windows cmd time date datetime (1) ibm db2 cognos installation example db deployment provisioning (1) ideas (1) image (1) informatica oracle sql (1) informatica repo sql workflows sessions file source dir (1) informatica source files etl (1) install (1) isg-pub issue-tracker architecture (1) it management best practices (1) java (1) jump to (1) keyboard shortcuts (1) ksh (1) level (1) linkedin (1) linux bash ansible hosts (1) linux bash commands (1) linux bash how-to shell expansion (1) linux bash shell grep xargs (1) linux bash tips and t ricks (1) linux bash unix cygwin cheatsheet (1) linux bash user accounts password (1) linux bash xargs space (1) linux cheat-sheet (1) linux cheatsheet cheat-sheet revised how-to (1) linux how-to non-root vim (1) linux ssh hosts parallel subshell bash oneliner (1) london (1) make (1) me (1) metacolumn (1) metadata functions (1) metaphonre (1) method (1) model (1) movie (1) multithreaded (1) mysql cheat sheet (1) mysql how-to table datatypes (1) n900 (1) nano (1) neteza (1) netezza bash linux nps (1) netezza nps (1) netezza nps nzsql (1) netezza nz Linux bash (1) netezza nz bash linux (1) netezza nz nzsql sql (1) netezza nzsql database db sizes (1) non-password (1) nord pol (1) nps backup nzsql schema (1) number formatting (1) nz db size (1) nz table count rows (1) nzsql date timestamp compare bigint to_date to_char now (1) on-lier (1) one-liners (1) one-to-many (1) oneliners (1) open (1) open source (1) openrowset (1) openssl (1) oracle PL/SQL (1) oracle Perl perl (1) oracle installation usability (1) oracle number formatting format-model ora-sql oracle (1) oracle templates create table (1) oracle trigger generic autoincrement (1) oracle vbox virtual box cheat sheet (1) oracle virtual box cheat sheet (1) outlook (1) parser (1) password (1) paths (1) perl @INC compile-time run-time (1) perl disk usage administration Linux Unix (1) perl modules configuration management (1) permissions (1) php (1) picasa (1) platform (1) postgreSQL how-to (1) powerShell cmd cygwin mintty.exe terminal (1) ppm (1) predictions (1) prices (1) principles (1) productivity (1) project (1) prompt (1) proxy account (1) public private key (1) publishing (1) putty (1) qt (1) read file (1) registry (1) relationship (1) repository (1) rm (1) scala ScalaFmt (1) scp (1) scripts (1) scsi (1) search and replace (1) sed (1) sendEmail (1) sh stub (1) shortcuts Windows sql developer Oracle (1) sidebar (1) silicon (1) smells (1) smtp (1) software development (1) software procurement (1) sofware (1) sort (1) sql script (1) sql_dev (1) sqlcmd (1) sqlite (1) sqlite3 (1) sshd (1) sshd cygwin (1) stackoverflow (1) stored procedure (1) stub (1) stupidity (1) subroutines (1) svn (1) sysinternals (1) system design (1) tail (1) tar (1) temp table (1) templates (1) teradata (1) terminal (1) test (1) testing (1) theory (1) thorium (1) time (1) tip (1) title (1) tmux .tmux.conf configuration (1) tmux efficiency bash (1) tool (1) ui code prototyping tips and tricks (1) umask Linux Unix bash file permissions chmod (1) url (1) urls (1) user (1) utility (1) utils (1) vb (1) vbox virtual box cheat sheet (1) vim perl regex bash search for string (1) vim recursively hacks (1) vim starter (1) vim-cheat-sheet vim cheat-sheet (1) vimeo (1) visual stuio (1) warsaw (1) wiki (1) wikipedia (1) window (1) windows 7 (1) windows 8 (1) windows programs (1) windows reinstall (1) windows utility batch perl space Windows::Clipboard (1) wisdoms (1) workflow (1) worth-reading (1) wrapper (1) xp_cmdshell (1) xslt (1) youtube (1)

Blog Archive

Translate with Google Translate

My Blog List