|
|
Posted by David Portas on 09/07/07 22:08
"Hamilton sucks" <caof@mcmaster.ca> wrote in message
news:1189201676.191048.77380@22g2000hsm.googlegroups.com...
> Hi:
> I need to add some records in a table called location(primary key:
> loc_id). What I want to do is for each location in the table, I add
> the same record but with a different loc_id, which can be a random
> string. All the other column should contain the same value. Can anyone
> give me a hint on how to do this in SQL server 2000 enterprise
> manager?
> thx.
>
A strange design. If the only key is random then how do you hope to retrieve
the information? If the rest of the data is to be identical then why bother
copying it?
DECLARE @loc_id VARCHAR(36);
SET @loc_id = CAST(NEWID() AS VARCHAR(36));
INSERT INTO location (@loc_id, col1, col2, ...)
SELECT col1, col2, ...
FROM location ;
--
David Portas
Navigation:
[Reply to this message]
|