Central Seed of Thought: SQL Check Query Return Results

Thursday, 4 July 2019

SQL Check Query Return Results

DECLARE @query nvarchar(MAX);
SET query = N'SELECT * FROM Table WHERE id=_id'

EXEC sp_executesql @queryToPass
IF ( @@ROWCOUNT > 0)
BEGIN
    -- action
END

No comments:

Subscribe to: Post Comments (Atom)