TSQL Tips – Modifying text in rows

I have been doing some loading of random text in tables, but wanted to make changes to some of the text in rows, instead of running a full update operation, I discovered that you can also use TSQL functions REPLACE or STUFF to change text. Below are examples: UPDATE Dbo.Table_1 SET c2 = (SELECT REPLACE(c2,’It’,’This’))…

2

SQL Server 2008 Developer Training Kit

Want some FREE training on the new developer features of SQL Server 2008? Download this developer training kit from – http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=e9c68e1b-1e0e-4299-b498-6ab3ca72a6d7. This kit contains examples, presentations, hands on labs. It works with Express Editions of SQL Server 2008 and Visual Studio.

0