SQL Server has a stored procedure that accepts a parameter of type text, and executes the code. This is useful if you need to run a large (over 8000 characters) dynamic query

sys.sp_sqlexec