How to insert different records into multiple sql tables with same uniqueidentifier in sql server

roy himanshu

17y4.9k

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Roei Bar17y ago

Accepted answer

your error is occurring since the id is not a unique identifier

here is the fixed Command:

 declare @myKey int
select 
@myKey = scope_identity()
insert into persons (id,lastname,firstname) 
values(@myKey,'hai','world') 
  
insert into persons1(id,c1,c2) 
values(@myKey,'hello','roy')

roy himanshu17y ago
thanx its working
himanshu
0