Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Comments on Execute SQL queries stored in a table
Post
Execute SQL queries stored in a table
+3
−0
Let's say I have a table with SQL statements in a column. I want to execute them all.
create table sql_command(
sql_text text
)
I know how to execute one SQL statement using EXEC
, but I want to do it for all statements in the table.
exec (sql_command) from (select sql_text from sql_command)
doesn't work.
1 comment thread