1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

DECLARE @userId INT = ##UserId##;
DECLARE @bodyValue NVARCHAR(MAX) = '##BodyValue##';

SELECT
  T1.*
FROM
  Posts AS T1
WHERE
  T1.OwnerUserId = @userId AND
  T1.Body LIKE CONCAT('%', @bodyValue, '%');

fork query

edited mar 4

created mar 3 Artfaith