sql不如access?????请教!!

我将用vb+access写的软件转移到vb+sql7下,却发现access中支持的format和iif函数到sql下统统不支持了,有解决办法吗??
多谢!!
---------------------------------------------------------------

iif函数可以用CASE代替.
format用CONVERT或者CAST代替.

---------------------------------------------------------------

As so.

Function Format,iif is some function can be used in jet sql
exact speaking, they are some function in VBA.

But in sql u can change format into convert or cast and
change iif into case .. when .. then .. [else ..] end

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus