james-dong-我的博客,我精彩

:: :: :: ::

case sql语句

摘要： SELECT [au_id],[au_fname], case [contract] when 0 then '无' when 1 then '有' end as '你想要的状态' FROM [pubs].[dbo].[authors] 阅读全文

posted @ 2007-04-26 10:36 james.dong 阅读(341) 评论(0) 推荐(0) 编辑