asked
Insert Statement
insert two phone no's into one column separated by comma with single insert statement CREATE table phone ( name varchar(20), contact varchar(30) ) Output: name Contact SSC 123-45-6789,987-65-4321'
Although the queries that @JohnM posted will insert the comma delimited numbers, I would strongly urge you to reconsider storing multiple delimited phone numbers in a single row/column. When a person with multiple phone numbers changes one (or more) of its numbers, how do you plan to update it? What if you want to find all persons that share a single number? Search by phone number? Delete one number? You're in for a maintenance nightmare if you take this approach. Just add a phone number table that has a foreign key referencing the person table and all of these uncomfortable maintenance problems go away. You will even be able to flag the phone numbers by type - LandLine, cellular, primary, secondary, etc.
Would this work? Given that I'm not 100% clear on what you are looking for but I thought that I'd just put something together. CREATE table #phone ( name varchar(20), contact varchar(30) ) GO -- Option #1 INSERT #phone (name, contact) VALUES ('SSC', '123-45-6789,987-65-4321') GO -- Option #2 INSERT #phone VALUES ('SSC', '123-45-6789,987-65-4321') GO -- Option #3 INSERT #phone (name, contact) SELECT 'SSC', '123-45-6789' UNION SELECT 'SSC', '987-65-4321' GO
16 People are following this question.
