Need Help for foreign key Constraint Query [Resolved]

YOU CAN ALSO WORK LIKE THIS
create table employee(empno int primary key,empname varchar(20),MgrEmpno int foreign key references employee(empno))
it references the the same table employee
Thanks And Regards
Avdesh

Yashodajagalur, if this helps please login to Mark As Answer. | Alert Moderator

if there is two tables i.e, employee and manager. First you have to create primary key for employee table
for example:

create table employee(employeename varchar(20),employeeNumber int constraint pk_Eno primary key, mangerEmpolyeeNumber int)

create table manger(EmployeeName varchar(20),mangerEmployeeNumber int constraint fk_mEmpNo foreign key reference employee(managerEmployeeNumber))

k.m.j.kiran

Yashodajagalur, if this helps please login to Mark As Answer. | Alert Moderator

Thanks for the help

Yashodajagalur, if this helps please login to Mark As Answer. | Alert Moderator

Can any one help me on WPF,I need proper code for the below query

1)We have three fields like FirstName,LastName and Age in the designer page after compilation

In the Main Page(Output or resulting page) only Name and Age Should Display

(I tried using concatenation of strings but I didn't get it)

(Name=FirstName + LastName) and it can't be editable.

How can we do that in WCF

Thanks & Regards
Yashoda

Yashodajagalur, if this helps please login to Mark As Answer. | Alert Moderator

PLEASE MARK AS ANSWER WHOSOEVER ANSWER IS CORRECT
THANKS AND REGARDS
AVDESH

Yashodajagalur, if this helps please login to Mark As Answer. | Alert Moderator

Hi Avhesh

u r query is for creating table with FK Constraint.But i want sql query which retrives all the data from the table using only FK.
How can we write a query for that?

Thanks & Regards
YGirish

Yashodajagalur, if this helps please login to Mark As Answer. | Alert Moderator

PRIMARY KEY TABLE:

CREATE TABLE EMP(EMPID INT CONSTRAINT PK_EMP PRIMARY KEY(EMPID) ,EMPNAME VARCHAR(90))

FOREIGN KEY TABLE:

CREATE TABLE EMPSALARY(EMPID INT REFERENCES EMP(EMPID),EMPSALARY MONEY)

HOPE THIS WILL HELP

REGARDS

SRIRAM.R

sriram

Yashodajagalur, if this helps please login to Mark As Answer. | Alert Moderator