$result = \think\Db::query("select GoodID,GoodType from GoodTable where exhition = 1 Order by fabulous desc;");

$result = \think\Db::table('GoodTable')->where('GoodID',$goodID)->find();


SQL Server2005, DSN ,param 要不要设置，设置怎么样？
'type' => 'sqlsrv',
// 服务器地址
'hostname' => '127.0.0.1',
// 数据库名
'database' => 'sun',
// 用户名
'username' => 'sa',
// 密码
'password' => '123456',
// 端口
'hostport' => '1433',
// 连接dsn
//'Provider = SQLOLEDB.1;Persist Security Info = True;Data Source=2011-20140412UX;Initial Catalog=sun;User Id=sa;Password=123456;',
'dsn' => '',
//'database=sun;hostname=127.0.0.1;',
//'Provider = SQLOLEDB.1;Persist Security Info = True;database=2011-20140412UX;Initial Catalog=sun;User Id=sa;Password=123456;',
//'odbc:Driver={SQL Server};Server=127.0.0.1;Database=sun;hostname = 127.0.0.1;',
// 数据库连接参数
'params' => ['Provider = SQLOLEDB.1;Persist Security Info = True;'],