Member Avatar for Transcendent

I have created a procedure and a table. I was wondering how can I call my procedure in a sql file and insert the result into my table?

  • 2 Contributors
  • 1 Reply
  • 81 Views
  • 1 Hour Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

If your stored proc returns a single value, you can just use it in your insert query.

INSERT INTO table (yourcolumn) VALUES (yourstoredproc())
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.