Sql Server Blog
Blog Archive
►
2012
(4)
►
November
(1)
►
June
(1)
►
April
(1)
►
February
(1)
►
2010
(8)
►
January
(8)
▼
2009
(9)
▼
November
(1)
Using Replace function to update whole column data...
►
October
(8)
Connect
C# DOT NET for Developers
ASP Developer
Followers
ClustrMaps of Visitors
About Me
Amit Pal
Associate Project Manager, HCL Technologies Ltd. Noida
View my complete profile
Sunday, November 1, 2009
Using Replace function to update whole column data in a table
Below is the table "tbl_interview" with the "description" column and we are updating "script src=" text with the blank "" text.
update tbl_Interview set description=Replace(description,'script src=','')
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment