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

Report this post to a moderator

Hi,

Create a temporary table with IDENTITY field and all fields from your table
that you want to export.
Feed the data from your source table into the temporary table.
The Identity field will contain unique values.
Export data from temporary table into text file.

Oleg.

> 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

Report this post to a moderator

Please do not post the same question independently to multiple newsgroups.

Please see my reply in .dts

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"dam" <ddesilva@accela.com> wrote in message
news:0b1c01c29cd2$479f4280$cef
82ecf@TK2MSFTNGXA08...
> 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

Report this post to a moderator