Link to home
Start Free TrialLog in
Avatar of zimmer9
zimmer9Flag for United States of America

asked on

How to input 2 values into 1 field using SQL Server 2005 with an insert statement?

I am using SQL Server 2005.

How would you insert 2 values into 1 field ELEMENT_TYPE_VALUE_PAIRS?

I tried the following
placing User_type & Master Access into ELEMENT_TYPE_VALUE_PAIRS
and got a syntax error.

INSERT INTO dbo.tblDirect_Entlmnts (PRINCIPAL_ID_TYPE, PRINCIPAL_NAME, ELEMENT_TYPE_VALUE_PAIRS)
values ('K', 'nitod', ('User_type', 'Master Access'));
ASKER CERTIFIED SOLUTION
Avatar of nilesh31
nilesh31

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial