Browsing articles in "MSSQL"
Sep
23
2010
23
2010
Replace text in MSSQL row
I just had to do a bulk find and replace in MSSQL on a databsae to change PizzaExpress to Pizza Express. Instead of having to go into each one and change one by one I could just use the following SQL Query. Much faster! UPDATE restaurants SET restaurantName = REPLACE(restaurantName ,’PizzaExpress’,'Pizza Express’) WHERE restaurantName like ‘%PizzaExpress%’
Tech Cloud
0x800A1391
2003 Server
adwords
adwords editor
Amazon
Apache
APC
Axigen
Backup
CentOS
Date
EC2
error 211
Error 1907
Fedora
google
Google Sitemap Generator
htaccess
HTML5
httpd.conf
iphone
Jira
mail
mailx
mkfs
MSSQL
MySql
MySql Server
Nutch
Office 2007
PHP
Rackspace Cloud
S3
Solr
strtotime
Subversion
Time
Tomcat
URL Rewrite
virus
vsftpd
Website Optimiser
Wordpress
XML
Zend

An article by tech-problems