quote:

---

Originally posted by praveensc2003

I am newbie to sql programming please help me solving this problem of mine

This is code
1.Created two tables
CREATE TABLE CONTACT(
CONTACTID INT,
FIRSTNAME VARCHAR(100),
MIDDELNAME VARCHAR(100),
LASTNAME VARCHAR(100),
CONSTRAINT pk_CONTACT_pid PRIMARY KEY(CONTACTID)
)
GO
CREATE TABLE EMPLOYEE(
CONTACTID INT,
EMPLOYEEID INT,
NationalIDNumber NVARCHAR(30),
LoginID nvarchar(512),
Title nvarchar(100)
CONSTRAINT pk_EMPLOYEE_sid PRIMARY KEY(EMPLOYEEID),
CONSTRAINT fk_EMPLOYEE_pid FOREIGN KEY(CONTACTID)REFERENCES CONTACT(CONTACTID)
)
GO
there is foreign key constraint on employee table

trying insert two tables with one insert statement with identity and condition

IT SHOULD INSERT DATA CONTAINING FIRST NAME 'HENRY' IN TO CONTACT TABLE AND CORRESPONDING LINKED DATA IN EMPLOYEE TABLE

IT SHOULD INSERT
DECLARE @CONTACTID INT
DECLARE @FIRST VARCHAR(100)
SET @FIRST='HENRY%'
INSERT INTO CONTACT(CONTACTID,FIRSTNAME,MIDDELNAME,LASTNAME)
SELECT ContactID,FirstName,MiddleName,LastName WHERE FIRSTNAME=@FIRST
FROM AdventureWorks.Person.Contact
SET @CONTACTID=@@IDENTITY
INSERT INTO EMPLOYEE(CONTACTID,EMPLOYEEID,NationalIDNumber,LoginID,Title)
SELECT CONTACTID,EMPLOYEEID,NationalIDNumber,LoginID,Title
FROM AdventureWorks.HumanResources.Employee


a

---