"varchar(n)"         varchar(4),   

  "nchar(n)"           nchar(4),     

  "nvarchar(n)"        nvarchar(4),  

  "binary(n)"          binary(6),    

  "varbinary(n)"       varbinary(6), 

  "varchar(max)"       varchar(max), 

  "nvarchar(max)"      nvarchar(max),

  "varbinary(max)"     varbinary(max),

  "Text"               Text,         

  "Ntext"              Ntext,        

  "Image"              Image        

)

--向各個字段插入相應的數據值

INSERT INTO testDataType(

  "bit","tinyint","smallint","int","bigint",

  "decimal(p,s)","numeric(p,s)",

  "smallmoney","money",

  "float","real",

  "datetime","date","time",

  "smalldatetime","datetime2","datetimeoffset",

  "char(n)","varchar(n)","nchar(n)","nvarchar(n)",

  "binary(n)","varbinary(n)",

  "varchar(max)","nvarchar(max)","varbinary(max)",

  "Text","Ntext","Image"

)