Wednesday, 15 May 2013

sql server 2005 - How to insert multiple values in single row in SQL? -



sql server 2005 - How to insert multiple values in single row in SQL? -

hey i'm stuck on sql problem past 4 days,how insert multiple values single row example-project table holds projects names,id, , other details employee holds employee details,there many many relation in project , employee,so want store many employees working in single or multiple projects. plz help me out.....

for need create new table saying employeeproject have foreign key employee table , project table , primary key of own table. new table

employeeproject ==> epid, emp_id, proj_id

in many-to-many relationship need create table links (maps) these 2 tables refer here

hope helps!

sql-server-2005

No comments:

Post a Comment