dynamic string - execute as sql-query

Question

I am writing a stored procedure by framing a dynamic string :

the following query is a string stored in a variable. How will I execute this string ?

 DELETE FROM PopularTrends          
 WHERE PopularID NOT IN           
 (          
 SELECT  PopularID          
 FROM   (SELECT *,          
           Row_number()          
             OVER(          
               PARTITION BY COUNTRY,HRefTopic          
               ORDER BY LastModifiedTime desc) AS RN          
    FROM   populartrends )A          
    WHERE  RN = 1          
 )

Arion · Accepted Answer · 2015-05-29 08:09:49Z

2

Like this:

DECLARE @query NVARCHAR(1000)
SET @query=N'DELETE FROM PopularTrends          
 WHERE PopularID NOT IN           
 (          
 SELECT  PopularID          
 FROM   (SELECT *,          
           Row_number()          
             OVER(          
               PARTITION BY COUNTRY,HRefTopic          
               ORDER BY LastModifiedTime desc) AS RN          
    FROM   populartrends )A          
    WHERE  RN = 1          
 )'
EXEC sp_executesql @query

Reference:

sp_executesql (Transact-SQL)

answered May 29, 2015 at 8:09

Arion

31.3k10 gold badges74 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

neydroydrec Over a year ago

Would you know what that would be in BigQuery?

Collectives™ on Stack Overflow

dynamic string - execute as sql-query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related