• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

SQL prepared statement

Hi,

I would like to know if it is good technique to define prepared statements at the top of a script and then execute them where needed or does it matter. is there a proper technique say including a page with them in it at the top
0
J N
Asked:
J N
1 Solution
 
GaryCommented:
Doesn't matter. Whichever works for you.
I use a mixture of both.
One off statements I declare as and when I need them.
Multi call statements I declare at the top.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now