PHWinfo - Afficher un message

07/09/2007, 22h47

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.

07/09/2007, 22h47	#1
Hamilton sucks Messages: n/a Hébergeur:	Add records in a table 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.