实例分析Sybase数据库Varchar类型的排序

  •   2008-04-26/14:26
  •  

    本文主要介绍了Sybase数据库Varchar类型的排序示例,具体内容请参考下文:

     

    1> select * from idid order by 1
    2> go
     id
     ----
     1
     10
     11
     2
     20
    
    (5 rows affected)
    1> select * from idid order by convert(integer,id)
    2> go
     id
     ----
     1
     2
     10
     11
     20
    
    (5 rows affected)
    1>

    评论 {{userinfo.comments}}

    {{money}}

    {{question.question}}

    A {{question.A}}
    B {{question.B}}
    C {{question.C}}
    D {{question.D}}
    提交

    驱动号 更多