When I search for “new1”, how to get all usernames. For example: I should get A and B as user IDs 1,2 in tblC is 1,2 and there is new for row1 1. What query should I use to get the above result?
I
Tag: comma
MSSQL SQL Server converts a comma-separated one column data to multiple column data.
Reprinted from: http://www.maomao365.com/?p=10278
Summary:
The following describes the method of separating single column data combined with commas in sqlserver into multiple columns of data