View previous topic :: View next topic
|
Author |
Message |
a027412
New User
Joined: 05 Jul 2007 Posts: 40 Location: Minneapolis, MN
|
|
|
|
Is it a safe assumption to say that any dynamic SQL will have "PREPARE" and/or "EXECUTE" keyword in it??? |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
PREPARE is a must but not EXECUTE.
If the query is fixed and no changes are required in future like column additons then PREPARE is enough, otherwise EXECUTE is a must |
|
Back to top |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008 Posts: 193 Location: chennai
|
|
|
|
Hi
Quote: |
PREPARE is a must but not EXECUTE. |
We can not come to a conclusion like this without going thru the requirement of the program. If the Dynamic Sql program is for NON-SELECT, we can say EXECUTE is a must not PREPARE. If it is Parameterized NON-SELECT, we need both PREPARE and EXECUTE. For Fixed list SELECT and Variable List SELECT, we do not need the EXECUTE statement but PREPARE is required.
Regards
Raghu |
|
Back to top |
|
|
|