本文介绍了根据ID合并两行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有带有选择,选择ID和问题ID之类的字段的表. 现在,我想将与一个问题相关的选择合并到一个语句中,然后插入第二个表中. 对于前 choiceId choiceName问题ID 1个1 2 b 2 questionId选择 1〜1〜2〜 我该怎么办?
I have table with fields like choices ,choice Id and question Id. Now i want to join this choices which are associated to a question into a single statement and insert into the second table. for ex choiceId choiceName questionId 1 a 1 2 b 2 questionId choices 1 ~1~2~ How can i do it ?
推荐答案请通过此链接 sqlyoga/2009/02/sql-server-get- comma-separated-list.html Please go through this link sqlyoga/2009/02/sql-server-get-comma-separated-list.html
更多推荐
根据ID合并两行
发布评论