YII pagination with SQL Server

Yii 1.1 General Discussion
1

Using this script

Yii::app()->db->createCommand()->setFetchMode(PDO::FETCH_OBJ)

->select(‘CITY_ID, CITY_NAME’)

->from("CITY")

->limit($rows)

->offset($offset)

->queryAll();

in MySQL running well but SQL Server cannot running well. How to my application running well with SQL Server ?? :huh:

Thanks