sql 快捷方法使用

UPDATE dbo.PingDingItem SET PinYin=REPLACE(PinYin,'熏','X') WHERE id IN(213)-----替换函数

select distinct stuff(
(
SELECT ',' + TypeName+'('+DoctorName+')' FROM order_RelatedDoctor with(nolock)
WHERE OperationRequestId='7CBDEE53-4E4E-4774-ADA0-9F310E52F7FB'
order by id desc
for xml path('') )

,1,1,''
)---------------连接函数