22,302
社区成员




declare @s varchar(300)
set @s = '''staff_id in(''F80D30'',''E53D6B'',''FC2E0E'',''006204'',''006117'',''006213'',''006220'',''ECFAB0'',''006216'')'''
print @s
set @s = '''staff_id' + char(10)
+ replace(replace(replace(replace(@s,'staff_id ',''),'(''','('''''),''')',''''')'),''',''',''''',''''')
print '--------------------------------------------------------'
print @s
/**
'staff_id in('F80D30','E53D6B','FC2E0E','006204','006117','006213','006220','ECFAB0','006216')'
--------------------------------------------------------
'staff_id
'in(''F80D30'',''E53D6B'',''FC2E0E'',''006204'',''006117'',''006213'',''006220'',''ECFAB0'',''006216'')'
**/
staff_id in('''F80D30''','''E53D6B''','''FC2E0E''','''006204''','''006117''','''006213''','''006220''','''ECFAB0''','''006216''')'