偶写的第一个SQLSERVER测试页面，庆祝一下。由于我的机器是XP home版的，不能安装企业版的服务器端程序，所以就用了开发版。
<?php
$conn = mssql_connect('127.0.0.1','webuser','test_webuser') or die('Can not connect');
$sql = "declare @testTable table(A int,B int,C int)
insert into @testTable select 1,10,5
insert into @testTable select 1,10,3
insert into @testTable select 2,20,4
insert into @testTable select 2,20,7
insert into @testTable select 3, 10, 9
insert into @testTable select 3, 10, 8
select * from @testTable;
Select SUM(B) As B From (Select Distinct A, B From @testTable) T order by B";
$result = mssql_query($sql,$conn);
while ($row1 = mssql_fetch_array($result)){
    $row[] = $row1;
}
print '<pre>';
print_r($row);
print '</pre>';
?>
============

Array
(
    [0] => Array
        (
            [0] => 1
            [A] => 1
            [1] => 10
            [B] => 10
            [2] => 5
            [C] => 5
        )

    [1] => Array
        (
            [0] => 1
            [A] => 1
            [1] => 10
            [B] => 10
            [2] => 3
            [C] => 3
        )

    [2] => Array
        (
            [0] => 2
            [A] => 2
            [1] => 20
            [B] => 20
            [2] => 4
            [C] => 4
        )

    [3] => Array
        (
            [0] => 2
            [A] => 2
            [1] => 20
            [B] => 20
            [2] => 7
            [C] => 7
        )

    [4] => Array
        (
            [0] => 3
            [A] => 3
            [1] => 10
            [B] => 10
            [2] => 9
            [C] => 9
        )

    [5] => Array
        (
            [0] => 3
            [A] => 3
            [1] => 10
            [B] => 10
            [2] => 8
            [C] => 8
        )

)