이것저것

SELECT DISTINCT t1.name AS keyName, OBJECT_NAME(t1.parent_object_id) AS tableName

, COL_NAME(t2.parent_object_id, t2.parent_column_id) AS columnName

FROM sys.foreign_keys t1 

JOIN sys.foreign_key_columns t2 ON t2.constraint_object_id = t1.OBJECT_ID

JOIN sys.tables t3 ON t3.OBJECT_ID = t2.referenced_object_id 

WHERE OBJECT_NAME (t1.referenced_object_id) = '테이블명'

데이터)

Idx      name

 1       가나다

 1       라마바

 1       사아자

쿼리)

DECLARE @arrName VARCHAR(1000)

SELECT @arrName = COALESCE(@arrName, '') + name + ','

FROM tbTest

WHERE Idx = 1

PRINT @arrName

결과)

가나다,라마바,사아자

DropDownList HTML 특수코드 적용

tip. HTML 특수코드 = HTML Character Entity(HTML 문자 단위(엔티티))

test.aspx

<asp:DropDownList ID="ddlList" runat="server" />

test.aspx.cs

ListItem item;

item = new ListItem();

item.Text = "대분류";

item.Value = objList.Rows[X]["DepartmentCD"].ToString();

ddlList.Items.Add(item);

item = new ListItem();

item.Text = HttpUtility.HtmlDecode("&nbsp;&nbsp;┖ ") + "중분류";

item.Value = objList.Rows[X]["DepartmentCD"].ToString();

ddlList.Items.Add(item);

적용 화면