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