桦山涧

桦山涧
Asp.net ---->知识改变命运!
posts - 261, comments - 171, trackbacks - 6, articles - 3
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

SELECT REPLACE( REPLACE((SELECT Name FROM common.Common_Setup_CompanyData T WHERE CompanyID<39 FOR XML AUTO),'<T Name="',','),'"/>',',')
DECLARE @dd NVARCHAR(1000)
SET @dd=( SELECT REPLACE((SELECT Name FROM common.Common_Setup_CompanyData T WHERE CompanyID<39 FOR XML AUTO),'<T Name="',',') )
SET @dd= REPLACE(@dd,'"/>','')
SELECT Stuff(@dd,1,1,'')