I needed to find and replace text in a text field in sql2000… here’s how I got it right: declare @StringToReplace varchar(1000) SET @StringToReplace = ‘baad string’ declare @NewString varchar(1000) SET @NewString = ‘new improved string’ declare @start int declare @end int SELECT @end = len(@StringToReplace)-2 declare @currentrecord int declare @ptrval BINARY(16) declare @TotalOldTextInstancesStillToBeFixed int [...]

Google analytics is fantastic. Add Jquery into the mix and things get even better. Want a script that will make sure that links to external sites and documents are tracked in analytics? Then look no further! All external links (links that begin with http:// or https://) will concatenate the current url + /outgoing/ + link [...]