SQL Server Technet
Friday, 27 June 2014
UPDATE and REPLACE TSQL
Find the example TSQL to use UPDATE statement with REPLACE function,
UPDATE
[AdventureWorks2008R2]
.
[Person]
.
[Person]
SET
FirstName
=
REPLACE
(
FirstName
,
'sam'
,
'jim'
)
Where
FirstName
=
'sam'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment