how to store multiple value in column in sql server I am creating job post application. In my first table the columns are This is my master table

ID
Position
jobDescription
minExp
maxExp
LastDate
InterviewDate
Project
HiringManager
interviewer
Primaryskills
SecondorySkills


and second table contains the primary skills PrimarySkill table

ID
PrimarySkills


third Table contains the secondory skills

ID
SecondarySkills


fourth Table contains the Interviewer

ID
Interviewer


the problem is that if a person have multiple skills and multiple interviewer for a job, Then how can insert the value from primary skill table, secondory skill table and interviewer table in Master table. i do not want to store value in comma separated
I don't think you want to store multiple values in a single column in the jobs table; this calls for what is known as a junction or many-to-many table.

CREATE TABLE dbo.Jobs
(
  JobID             INT PRIMARY KEY,
  JobTitle          VARCHAR(255),
  JobDescription    NVARCHAR(4000),
  MinimumExperience TINYINT,
  MaximumExperience TINYINT,
  LastDate          DATETIME, -- what is this? Needs a better name I think
  InterviewDate     DATETIME, -- is this really a property of the job?
  ProjectID         INT, -- foreign key references dbo.Projects?
  HiringManagerID   INT, -- foreign key references Employees table?
  InterviewerID     INT  -- foreign key references something?
);


(Assuming there is only one interviewer. If there are multiple, consider a many-to-many table.)

CREATE TABLE dbo.Skills
(
  SkillID SMALLINT PRIMARY KEY,
  SkillName VARCHAR(255) NOT NULL UNIQUE
);

CREATE TABLE dbo.JobSkills
(
  JobID INT NOT NULL FOREIGN KEY REFERENCES dbo.Jobs(JobID),
  SkillID SMALLINT NOT NULL FOREIGN KEY REFERENCES dbo.Skills(SkillID),
  IsPrimary BIT NOT NULL DEFAULT 1
);