Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Copy/Paste uniqueidentifier?

Status
Not open for further replies.
MeMark

MeMark

Programmer
May 8, 2006
2
SI
How can I "copy" the uniqueidentifier value of a row in one table and "paste" it into another using SQL Server 2000?
Thanks!
 
Sort by date Sort by votes
Could you do a
Code: 
UPDATE dest_table
   SET dest_UIDfield = (SELECT source_UIDfield
                        FROM source_table
                        WHERE condition_uniquely_finds_source)
WHERE condition_uniquely_finds_dest

or is there more than one you need to get?
 
Upvote 0 Downvote
Sorry I didn't clarify...it should be an INSERT to a table. I THINK I figured it out using cursor/fetch statements.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EM1107
  • Locked
  • Question
Copy folder and content using SQL Server TSQL.
Replies
6
Views
564
RobertPhillips
RobertPhillips
davismar
  • Locked
  • Question
SQL Statement to copy value from field1 to field2 then clear data in field 2 2
Replies
4
Views
178
davismar
davismar
Dhyerwolf
  • Locked
  • Question
Copy Direction Must be in, out or format
Replies
3
Views
123
jbenson001
jbenson001
nbhariyani
  • Locked
  • Question
Copy Data using Linked Server or Bulk Copy or SSIS ??? 1
Replies
3
Views
136
nbhariyani
nbhariyani
VIJSQL01
  • Locked
  • Question
BCP(Bulk Copy Program) is failing for a large file
Replies
10
Views
409
gk53
gk53

Part and Inventory Search

Sponsor

Back
Top