i want to insert multiple int values selected from dropdown in to a single column seperated by a delimiter(,)
along with this values there are some other rows too in which some other values are inserted
a table has
Booking id which contain values like 1
and roomid which contain values like 1,2,3
how can i do it using sql server insert query
i want to insert multiple int values selected from dropdown in to a single column seperated by a delimiter(,)
along with this values there are some other rows too in which some other values are inserteda table has
Booking id which contain values like 1
and roomid which contain values like 1,2,3how can i do it using sql server insert query
Just make the column that will store the delimited list of integers into a varchar(50) and create the delimited list in code and write it to the DB table column.
That's all folks
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.