Click here to Skip to main content
15,903,033 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL query Pin
John-thKing16-Apr-03 4:48
sussJohn-thKing16-Apr-03 4:48 
GeneralRe: SQL query Pin
John Honan16-Apr-03 4:54
John Honan16-Apr-03 4:54 
GeneralRe: SQL query Pin
greg lynch _nj_17-Apr-03 3:07
greg lynch _nj_17-Apr-03 3:07 
GeneralRe: SQL query Pin
si_6917-Apr-03 5:08
si_6917-Apr-03 5:08 
GeneralDummies guide to SQL Pin
Michael P Butler15-Apr-03 23:14
Michael P Butler15-Apr-03 23:14 
GeneralRe: Dummies guide to SQL Pin
perlmunger16-Apr-03 5:44
perlmunger16-Apr-03 5:44 
Generalfield=field+', ' in SQL Pin
stefan b15-Apr-03 23:08
stefan b15-Apr-03 23:08 
GeneralRe: field=field+', ' in SQL Pin
Jeremy Oldham16-Apr-03 2:29
Jeremy Oldham16-Apr-03 2:29 
GeneralRe: field=field+', ' in SQL Pin
stefan b16-Apr-03 18:47
stefan b16-Apr-03 18:47 
GeneralSQL 2000 Backup to SQL 7 Backup Pin
Paul Watson15-Apr-03 22:10
sitebuilderPaul Watson15-Apr-03 22:10 
GeneralRe: SQL 2000 Backup to SQL 7 Backup Pin
Paul Watson15-Apr-03 22:57
sitebuilderPaul Watson15-Apr-03 22:57 
GeneralUpdating Multiple records through Storedprocedure and getting event notifications Pin
Mairaj Zeb15-Apr-03 20:42
Mairaj Zeb15-Apr-03 20:42 
Generaldata mining Pin
devvvy15-Apr-03 16:58
devvvy15-Apr-03 16:58 
GeneralSQL data to create directories Pin
gman4415-Apr-03 4:41
gman4415-Apr-03 4:41 
GeneralRe: SQL data to create directories Pin
Richard Deeming15-Apr-03 6:51
mveRichard Deeming15-Apr-03 6:51 
GeneralRe: SQL data to create directories Pin
si_6917-Apr-03 5:46
si_6917-Apr-03 5:46 
Generalreading a single record from SQL Pin
gollnick15-Apr-03 0:47
gollnick15-Apr-03 0:47 
GeneralRe: reading a single record from SQL Pin
perlmunger16-Apr-03 5:39
perlmunger16-Apr-03 5:39 
QuestionMS Access & BatchUpdate throw ADO ? Pin
rosen14-Apr-03 3:50
rosen14-Apr-03 3:50 
Generalsearch syntax problem Pin
ylaine14-Apr-03 1:09
ylaine14-Apr-03 1:09 
GeneralDataViewManager, Rowfilters and Child Filtering Pin
xpurt14-Apr-03 0:44
xpurt14-Apr-03 0:44 
GeneralDynamic SQL with in a stored procedure Pin
Venkatraman13-Apr-03 17:56
Venkatraman13-Apr-03 17:56 
Hi, This is a repost of mine from Lounge.

I would like to know the implications of using dynamic sql with in a stored procedure, how it affects execution plan, what is the pros and cons of EXECUTE IMMEDIATE, the oracle native dynamic sql execution command.

please give me pointers to relevant resources.




Cheers,
Venkatraman Kalyanam
Chennai - India

"Being Excellent is not a skill, it is an attitude"
GeneralPersonal Sql Server Pin
Steve McLenithan13-Apr-03 9:14
Steve McLenithan13-Apr-03 9:14 
GeneralRe: Personal Sql Server Pin
perlmunger16-Apr-03 6:01
perlmunger16-Apr-03 6:01 
GeneralRe: Personal Sql Server Pin
Steve McLenithan16-Apr-03 6:15
Steve McLenithan16-Apr-03 6:15 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.