How a dynamic SQL can be executed?

Q & ACategory: DatabaseHow a dynamic SQL can be executed?
Admin Staff asked 3 years ago

How a dynamic SQL can be executed?

1 Answers
Admin Staff answered 3 years ago

Below are the three methods to run dynamic SQL.
(a)By writing a query with specific parameters
(b)By using the EXEC
(c)By using the sp_executesql