same uniqueidentifier

Question

Hi,All How to insert different records into multiple sql tables with same uniqueidentifier in sql server. thanx

roy himanshu · Answer

declare @myKey uniqueidentifier select @myKey = newId () insert into persons ( id , lastname , firstname ) values ( @myKey , 'hai' , 'world' ) insert into persons1 ( id , c1 , c2 ) values ( @myKey , 'hello' , 'roy' ) hi,this is my code.but still now iam getting error.the error message also i pasted here.plz rectifie my problem,plz.iam faceing this problem since several hours.plz help me. the error message is Msg 206, Level 16, State 2, Line 5 Operand type clash: uniqueidentifier is incompatible with int Msg 206, Level 16, State 2, Line 9 Operand type clash: uniqueidentifier is incompatible with int

Roei Bar · Answer

declare @myKey uniqeidentifier select @myKey = newId() insert into TableA (id,Name) values(@myKey,'roy') insert into TableB (id,Name) values(@myKey,'roy')

roy himanshu · Answer

hi, thanks for ur response,but still iam not getting output.plz give the syntax clearly.plz

Roei Bar · Answer

well my fridend the idea of Uniqeidentifier is that its uniqe, if you want to put the same key on 2 differant tables just do the following declare @myKey uniqueidentifier select @myKey = newId() and than do the insert to your Tables with the @myKey Indicator if you liked this dont forget to mark it as "Accepted Answer"

same uniqueidentifier

Answers (4)