update tb set inputfromsql=replace(inputfromsql,' where ',' where a.state=1 and ')

------解决方案--------------------
SQL code

--不知道你的字段需要格式下不？你确认全部替换的话，先执行看这个语句报错不
update tb 
set inputfromsql=replace(inputfromsql,N'where',N'where a.state=1 and')

------解决方案--------------------
SQL code

update tb 
set inputfromsql=replace(inputfromsql,' where ',' where a.state=1 and ')