Results 1 to 2 of 2

Thread: SQL Server

  1. 08-22-2008, 11:21 AM #1
    Ganeshag777
    Ganeshag777 is offline Member
    Join Date
    Aug 2008
    Posts
    7
    Rep Power
    0

    Default SQL Server

    how can i find rowid in Sql server database as like in oracle.
    Reply With Quote Reply With Quote
  2. 01-12-2009, 03:37 PM #2
    subrahmanyam.adapa
    subrahmanyam.adapa is offline Member
    Join Date
    Jan 2009
    Posts
    14
    Rep Power
    0

    Default

    You can use row_number orderby one colums as below :

    select row_number() over
    (order by pk_idx_data_id) as rownum, empname,empsal from Employeetable
    Reply With Quote Reply With Quote
« Hi | Default values of stored procedures »

Similar Threads

  1. SQL server
    By elish11 in forum JDBC
    Replies: 2
    Last Post: 08-20-2008, 06:00 PM
  2. Does any file in an FTP server ends up in an HTTP server?
    By islamfunny in forum CLDC and MIDP
    Replies: 4
    Last Post: 08-15-2008, 04:30 PM
  3. Web-App server connection - How to hit the particular app server from the web server
    By maruthi_s in forum Enterprise JavaBeans (EJB)
    Replies: 2
    Last Post: 07-15-2008, 06:11 PM
  4. One server to another server redirection
    By chaudhuri_abhi in forum Java Servlet
    Replies: 1
    Last Post: 02-11-2008, 07:05 PM
  5. WAS Server
    By Albert in forum Enterprise JavaBeans (EJB)
    Replies: 1
    Last Post: 06-25-2007, 05:38 AM

Bookmarks

Posting Permissions

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

Forum Rules