create a unique id for each row

[dam]

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

[David Satz]

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