摘要:SQL 複選欄位處理...
正常來說多選當然要開下檔比較好，但有時候古老的遺物已經是這樣開
A34,A35 來紀錄複選問題..查詢時要對應相對的中文時，總時有點小麻煩...
此時寫個小 function 來處理一下也是可以考量的方向...不過效能應該不會太好^^
Create Function [dbo].[fn_SUP_Text] ( @sup_code nvarchar(255) )
Returns nvarchar(255)
As
Begin
Set @sup_code = ',' + @sup_code + ','
Declare @Out nvarchar(255)
Select @Out = IsNull(@Out,'') + IsNull(CodeNameCH,'') + ','
From WasteCode
Where
@sup_code Like '%,' + CodeNo + ',%'
Return @Out;
End
Select dbo.fn_SUP_Text('A34,A35')
Returns nvarchar(255)
As
Begin
Set @sup_code = ',' + @sup_code + ','
Declare @Out nvarchar(255)
Select @Out = IsNull(@Out,'') + IsNull(CodeNameCH,'') + ','
From WasteCode
Where
@sup_code Like '%,' + CodeNo + ',%'
Return @Out;
End
Select dbo.fn_SUP_Text('A34,A35')