same uniqueidentifier

Question

HiAll 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' ) hithis is my code.but still now iam getting error.the error message also i pasted here.plz rectifie my problemplz.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 (idName) values(@myKey'roy') insert into TableB (idName) values(@myKey'roy')

roy himanshu · Answer

hi thanks for ur responsebut 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