December 8, 2011 at 2:23 am
an option using find and replace in SSMS, would be to replace all ' with '+char(39)+' except for the first and last ' so that it looks something like this
create table #table1 (html varchar(max))
INSERT #Table1 (Html)
SELECT
'<table cellpadding='+char(39)+
'0'+char(39)+
' cellspacing='+char(39)+
'0'+char(39)+
' border='+char(39)+
'0'+char(39)+
' id='+char(39)+
'Table2'+char(39)+
'><tr><td align='+char(39)+
'center'+char(39)+
'><img src='+char(39)+
'{0}'+char(39)+
' alt='+char(39)+
''+char(39)+
' border='+char(39)+
'0'+char(39)+
'></td></tr><tr><td align='+char(39)+
'center'+char(39)+
'><a href='+char(39)+
'{1}'+char(39)+
'><script language='+char(39)+
'JavaScript'+char(39)+
'> document.write('+char(39)+
'<form name="jpform{2}"><input name="progressive{2}" id="progressive{2}" readonly style="background-color : transparent; border-bottom-color: #99ffff; border-bottom-width: 0px; border-left-color: #99ffff; border-left-width: 0px; border-right-color: #99ffff; border-right-width: 0px; border-top-width: 0px; color: #000000; font-family: verdana; font-size: 12px; font-weight: bold; height: 15px; width: 115px;text-align : center;"></form>'+char(39)+
');ScrollProgressiveCounters({2});</script></a></td></tr><tr><td align='+char(39)+
'center'+char(39)+
'> <select onchange='+char(39)+
'window.location.href=(this.options [this.selectedIndex].value + "?{4}=ree{3}&a=regerggarg")'+char(39)+
';><option value='+char(39)+
''+char(39)+
'>Go</option> <option value='+char(39)+
'http://www.website.com'+char(39)+
'>Website</option><option value='+char(39)+
'http://www.website2.com'+char(39)+
'>Website2</option> <option value='+char(39)+
'http://www.j3.com'+char(39)+
'>Flash3</option> <option value='+char(39)+
'http://www.sdafsdfadsfa.com'+char(39)+
'>sadfasdf</option> <option value='+char(39)+
'http://www.dddddddddd.com'+char(39)+
'>dddddddddd</option> </select></td></tr></table>'
SELECT * FROM #table1
Viewing post 16 (of 15 total)
You must be logged in to reply to this topic. Login to reply