<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=32397)
    
        
    
          		
    
    
    
    
    
      --  作者：炙天
    
        --  發布時間：2011/1/13 8:37:56
    
        
        --  SQL Server 2008連載之數據類型四
    
        
    SELECT
		
      1,123,12345,1234567890,1234567890123456789,
      987654.3210,9876.543210,
      123456.7890,123456789012345.6789,
      1234567890.1234567890,1234567890.1234567890,
      \'2010-01-01 23:59:59.123\',\'2010-01-01\',\'23:59:59. 1234567\',
      \'2010-01-01 23:59:59\',\'2010-01-01 23:59:59.1234567\',\'2010-01-01 23:59:59.1234567 +12:00\',
      \'abcd\',\'abcd\',\'王保強\',\'王保強\',
      CONVERT(BINARY,\'123456\'),CONVERT(BINARY,\'123456\'),
      \'1234567890\',\'1234567890\',CONVERT(BINARY,\'1234567890\'),
      \'1234567890\',\'1234567890\',\'1234567890\'
    --使用system_internals_allocation_units來獲取該表的相關數據頁
    SELECT
			c.name,a.type_desc,
           total_pages,used_pages,data_pages,
           testdb.dbo.f_get_page(first_page)
			first_page_address,
           testdb.dbo.f_get_page(root_page)
			root_address,
           testdb.dbo.f_get_page(first_iam_page)
			IAM_address
      FROM
			sys.system_internals_allocation_units
			a,sys.partitions
			b,sys.objects
			c
     WHERE
			a.container_id=b.partition_id
			and
			b.object_id=c.object_id
       AND
			c.name
			in
			(\'testDataType\')    
    --再使用dbcc page命令分析相關頁面信息
    
        
    
          		
    
    

    
Channel