<address id="thnfp"></address>

    <address id="thnfp"><th id="thnfp"><progress id="thnfp"></progress></th></address>
    <listing id="thnfp"><nobr id="thnfp"><meter id="thnfp"></meter></nobr></listing>
    以文本方式查看主題

    -  安易免費財務軟件交流論壇  (http://m.gangyx.cn/bbs/index.asp)
    --  電腦知識交流  (http://m.gangyx.cn/bbs/list.asp?boardid=11)
    ----  SQL Server 2008連載之數據類型三  (http://m.gangyx.cn/bbs/dispbbs.asp?boardid=11&id=32396)

    --  作者:炙天
    --  發布時間:2011/1/13 8:36:39
    --  SQL Server 2008連載之數據類型三
     "char(n)"            char(4),      

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

    )


    Channel