SQL 引号和修改数据库字段内容
declare @sql varchar(500) set @sql= 'print ''一般字符''' exec (@sql) set @sql= 'print ''一般"字符"''' exec (@sql) set @sql= 'print ''一般''''字符''''''' exec (@sql) create proc ReplaceString @tablename nvarchar(50),@fieldname nvarchar(50),@exp1 nvarchar(50),@exp2 nvarchar(50),@whereExp nvarchar(50),@wherefield nvarchar(50)asDECLARE @Sql nvarchar(1000)set @Sql='update '+@tablename+' set '+@fieldname+'=replace('+@fieldname+','''+@exp1+''','''+@exp2+''') where '+@wherefield+' in (select '+@wherefield+' from '+@tablename+' where '+@fieldname+' like '''+@whereExp+''')'EXEC sp_executesql @Sql print @Sqlgo?