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
[356 byte] By [
dam] at [2007-11-9 21:10:52]
# 1 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.dev-archive.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
