John W. Colby
jcolby at colbyconsulting.com
Tue Mar 4 17:25:30 CST 2003
But what I am reading is that if you are talking about a situation like I am discussing, where the filter changes every time the sproc is used, the compile is actually counterproductive. John W. Colby Colby Consulting www.ColbyConsulting.com I've stopped 9,258 spam messages. You can too! Get your free, safe spam protection at http://www.cloudmark.com/spamnetsig/ -----Original Message----- From: dba-sqlserver-admin at databaseadvisors.com [mailto:dba-sqlserver-admin at databaseadvisors.com]On Behalf Of Susan Zeller Sent: Tuesday, March 04, 2003 6:15 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]Passing the SQL Setting to a stored procedure Another big problem is that this is like tying the hands of the sproc. Part of the power of the sproc is its efficiency from compiling. Sprocs that execute dynamic sql do not compile. --Susan -----Original Message----- From: David McAFee (Home) [mailto:dmcafee at pacbell.net] Sent: Tuesday, March 04, 2003 4:49 PM To: dba-sqlserver at databaseadvisors.com; AccessD Subject: RE: [dba-SQLServer]Passing the SQL Setting to a stored procedure Yes, but why not build it in the back, then any changes that would need to be made, could be made in the BE (by modifying the SPROC) without a need for a FE update? There is also a security risk involved, if anyone was to ever figure out the sproc's name you could possibly send a TRUNCATE command or some other ill script (or at least that's what I was told when I wanted to do this :) ) HTH David McAfee -----Original Message----- From: dba-sqlserver-admin at databaseadvisors.com [mailto:dba-sqlserver-admin at databaseadvisors.com]On Behalf Of John W. Colby Sent: Tuesday, March 04, 2003 2:36 PM To: AccessD-SQLServer; AccessD Subject: [dba-SQLServer]Passing the SQL Setting to a stored procedure I just had a fascinating idea. I do a lot of building up of SQL Strings then executing them in A2K. Would it be possible to build a stored procedure where the parameter passed in is the SQL statement to be executed? IOW, do the same thing we do now, manually build a SQL string with the actual values of controls in where clauses etc., then pass that string to a stored procedure and have the stored procedure execute the SQL string and hand back the data? John W. Colby Colby Consulting www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com ---------------------------------------------------- Is email taking over your day? Manage your time with eMailBoss. Try it free! http://www.eMailBoss.com -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 2920 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/dba-sqlserver/attachments/20030304/21b9a8a1/attachment.bin>