如何从动态SQL查询中分隔为单行的表逗号中获取数据？ [英] How to fetch data from a table comma separated as a single row in a dynamic SQL query?

问题描述

我想从动态sql查询中分隔为单行的表格逗号中获取数据



我尝试过：

I want to fetch data from a table comma separated as a single row in a dynamic sql query

What I have tried:

DECLARE @COLUMNS NVARCHAR(max)
SELECT @COLUMNS = 
  CM.ColumnName
  FROM ICCS_StdReportTable_Master TM                                                                    
  inner join                                                
  ICCS_StdReport_Column_Master  CM                                           
  on CM.TableId=TM.TableId                                           
  where                  
  tm.RecordIdentifierKeyword in (  
   select SUBSTRING(VALUE,TM.StartPosition,TM.Length) from ICCS_MENUS MNU  
   INNER JOIN  
   ICCS_StdReportTable_Master TM   
   ON TM.TableName=SUBSTRING(VALUE,TM.StartPosition,TM.Length) 
   INNER JOIN
   ICCS_SCREENS SC
   ON SC.SCREENID=MNU.SCREENID
   AND MNU.MENUID=117)

推荐答案

一般来说，这样做是一个糟糕的主意 - 插入原始值很容易，但是从那一点到很大程度上它会使其他一切变得复杂。最好先把它做成一个更好的主意，把一张单独的桌子和一把外键放回原来。



但如果你必须这可能会有所帮助执行此操作：将列中逗号分隔的数据转换为行供选择 [ ^ ]

Generally speaking it's a poor idea to do this - it's easy to insert the original values, but it complicates everything else from that point on to a massive degree. It's a much better idea to do it properly in the first place, with a separate table and a foreign key back into the original.

But this may help if you must do it: Converting comma separated data in a column to rows for selection[^]

Google搜索是您的朋友：从表格逗号中获取数据，在动态中分隔为单行sql查询 - Google搜索 [ ^ ] br />


以上搜索出现了这个宝石： mysql - 如何使用SQL查询创建逗号分隔列表？ - 堆栈溢出 [ ^ ]

Google search is your friend: fetch data from a table comma separated as a single row in a dynamic sql query - Google Search[^]

The above search turned up this gem: mysql - How do I Create a Comma-Separated List using a SQL Query? - Stack Overflow[^]

这篇关于如何从动态SQL查询中分隔为单行的表逗号中获取数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！