Converting MySQL to MS-SQL. it was not that straight forwards than I thought;
one of the pieces broken was CDbExpression(‘NOW()’);
I know I could search and replace all, but would be nice if we have a generic function to handle this regardless what db is?
update
thought about create mssql function, however, syntax-wise i have to have [dbo].NOW() meaning code change anyway, so I come up this, might be useful solution to someone else?