0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, teachers and students of the Ukrainian language

DECLARE	@TempTable AS TABLE(ID INT, DescriptionText VARCHAR(50))
INSERT INTO @TempTable
SELECT		1, 'Replace my name - Jimmy'

INSERT INTO @TempTable
SELECT		2, 'Replace my name - Jimmy'

INSERT INTO @TempTable
SELECT		3, 'Replace my name - Jimmy'

INSERT INTO @TempTable
SELECT		4, 'Replace my name - Jimmy'

INSERT INTO @TempTable
SELECT		5, 'Replace my name - Jimmy'

SELECT	*
FROM	@TempTable

UPDATE	@TempTable
SET		DescriptionText = REPLACE(DescriptionText, 'Jimmy', 'Dallas')

SELECT	*
FROM	@TempTable

fork query

created mar 7 12 anonymous