CREATEFUNCTION convertMultiRowsToChar(@idint) RETURNSvarchar(50) ASBEGINDECLARE@sqlvarchar(50) SET@sql='' SELECT@sql=@sql+','+cast(Name ASvarchar) FROM TableName WHERE Id =@idRETURNstuff(@sql, 1, 1, '') END
posted on
2007-07-27 16:13seamanhy
阅读(1360)
评论(0)
编辑收藏举报