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'

1 comment:

  1. For instance, in Europe, 3-axis machines value CNC machining round $40 per hour whereas 4-axis and 5-axis machines value between $75 to $120 per hour. Computer numerical control milling is applicable in making many aeronautic components using supplies corresponding to Titanium and Aluminum. Due to the high need for accuracy and precision, the method is considered suitable. Plain milling is a column and knee operation used for milling plain horizontal surfaces.

    ReplyDelete