T-sql update table variale

This article is tagged with: T-sql update table variale and mysql

t-sql update table variale

UPDATE @searchResult
SET [record_id] = r.[record_id],
[record_name] = r.[record_name]
FROM @searchResult SR
CROSS APPLY (
SELECT TOP 1 *
FROM [records]
WHERE [record_name] LIKE [name_template] -- Your wish, but do you really need LIKE matching??
ORDER BY [record_id] DESC
) AS r;

This article is tagged with: T-sql update table variale and mysql