[AccessD] [dba-SQLServer]Passing the SQL Setting to a stored procedure

Hello John,

Why not just pass the SQL raw and not bother with the sp in the first place?

I know that there are pro's and con's to using sp's, but if you are going to
do what you are doing, it seems like it would be just easier to send the raw
SQL.

Of course there are security issues with sending SQL, but leaving that
aside, why not send it raw?

I have not used it, but there is a kind of Execute Command that you can
include in a sp, maybe that could action the parameter that you would pass
in.

Mark



----- Original Message -----
From: "John W. Colby" <jcolby at colbyconsulting.com>
To: "AccessD-SQLServer" <dba-sqlserver at databaseadvisors.com>; "AccessD"
<AccessD at databaseadvisors.com>
Sent: Tuesday, March 04, 2003 10:36 PM
Subject: [AccessD] [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
>
>
> I've stopped 9,257 spam messages. You can too!
> Get your free, safe spam protection at
http://www.cloudmark.com/spamnetsig/
>
> ----------------------------------------------------
> Is email taking over your day?  Manage your time with eMailBoss.
> Try it free!  http://www.eMailBoss.com
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>