Results 1 to 2 of 2

Thread: Function

  1. #1
    Join Date
    Jul 2004
    Posts
    268

    Unanswered: Function

    What is the equivalent of sybase number function (number (*) ) in sql server 2008?

  2. #2
    Join Date
    Apr 2012
    Posts
    213
    I'm not sure because I do not know the SyBase, but try something like that:

    Code:
    select t.*, ROW_NUMBER() OVER(ORDER BY t.Name) AS RowNo
    from MyTable as t
    Hope this helps.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •