Update A
Set MachinesList='256','257',‘268’
Where ID=158这里machineList 的定义是 varchar(200)我需要插入的字符串里需要有 ' ,请问怎么插入多谢!
Set MachinesList='256','257',‘268’
Where ID=158这里machineList 的定义是 varchar(200)我需要插入的字符串里需要有 ' ,请问怎么插入多谢!
Update A
Set MachinesList='''256'',''257'',''268'''
Where ID=158
以下三种写法,看LZ想用哪个了:SELECT '''256'',''257'',''268'''
SELECT QUOTENAME('256','''')+','+QUOTENAME('257','''')+QUOTENAME('268','''')
SELECT QUOTENAME('256',CHAR(39))+','+QUOTENAME('257',CHAR(39))+QUOTENAME('268',CHAR(39))