Sql Server Unique Identifier
Posted: Mon Sep 17, 2012 10:47 am
Hello Gurus
Here is the problem
I need to insert Columns A and B from say table T1 to Table T2 . Table T2 has primary key defined as column PK1(GUID) .
Now lets say I have one row corresponding to Column A and B from T1 that I need to insert into T2 .
When I do the usual insert into Table T2 (Sql Server ) , Should I be using User Defined SQL to load into T2, if yes how would I take care of the GUID (PK1) here ?
Any help is appreciated .
I have searched for this topic with Key works GUID and SQL Server Unique ID but could not find any direct answers .
Here is the problem
I need to insert Columns A and B from say table T1 to Table T2 . Table T2 has primary key defined as column PK1(GUID) .
Now lets say I have one row corresponding to Column A and B from T1 that I need to insert into T2 .
When I do the usual insert into Table T2 (Sql Server ) , Should I be using User Defined SQL to load into T2, if yes how would I take care of the GUID (PK1) here ?
Any help is appreciated .
I have searched for this topic with Key works GUID and SQL Server Unique ID but could not find any direct answers .