Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
Community Proposals
Community Proposals
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »
Q&A

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.

History
Why does this post require attention from curators or moderators?
You might want to add some details to your flag.
Why should this post be closed?

1 comment thread

More details / the goal (2 comments)
More details / the goal
Alexei‭ wrote 2 months ago

Can you provide more information about the end goal of this? Are those statements only changing data or are they also SELECT statements?

Did you consider using a function or stored procedure? Is there a real need for such dynamicity (execute arbitrary statements from a table)?

talex‭ wrote 2 months ago

I need mass rename primary keys in table (don't ask why, I don't know). So I generated DDL for that. Now I need to execute them. We have several databases, so I want script that easily portable.

I prefer to avoid creation additional stored procedures or functions.