REPLACE function · DECLARE @str AS VARCHAR(100) · SET @str='ma' · SELECT name, (LEN(REPLACE(name, @str, @str + @str)) - LEN(name))/LEN(@str) FROM Ships.
確定! 回上一頁