Andile Choko

Andile Choko

  • NA
  • 53
  • 53.2k

How do u insert the same Uniqueidentifier from two different tables

Jun 3 2011 9:33 AM
Hi,

I have  created two tables:
 
create table dawie
(
Id uniqueIdentifier default newId() primary key,
name varchar(25)
)


create table chk
(
guid uniqueIdentifier primary key,
name varchar(10),
id uniqueIdentifier foreign key references dawie(Id)
)
 

Now how do i insert into both tables using stored procedures?

the previous solution worked, thanx.
 
How do i do the same using 2 stored procedures,i.e.
 
  create  proc insert_into_chk 
(
)

create proc  insert_into_ dawie  
(
)




Answers (1)