create a unique id for each row


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: create a unique id for each row

  1. #1
    dam Guest

    create a unique id for each row


    I need to create few txt files from an existing MSS db using some scripts.
    In the txt file, I need to create a new id column for each row. I like
    to use some function in my SQL scripts so it will create a unique id for
    each row. Any ideas?

    Id column needs to be less that 18 characters.(I cannot use NEWID() function)

    THNNKS

  2. #2
    David Satz Guest

    Re: create a unique id for each row

    you could use the IDENTITY (Function):
    SELECT column_list
    , IDENTITY ( data_type [ , seed , increment ] ) AS column_name
    INTO new_table
    --
    HTH,
    David Satz
    Principal Web Engineer
    Hyperion Solutions

    "dam" <ddesilva@accela.com> wrote in message
    news:3df00d5d$1@tnews.web.devx.com...
    >
    > I need to create few txt files from an existing MSS db using some scripts.
    > In the txt file, I need to create a new id column for each row. I like
    > to use some function in my SQL scripts so it will create a unique id for
    > each row. Any ideas?
    >
    > Id column needs to be less that 18 characters.(I cannot use NEWID()

    function)
    >
    > THNNKS




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center