SQL Server - Stored Procedures

Results 1 to 2 of 2

Thread: SQL Server - Stored Procedures

  1. #1
    Join Date
    Dec 1969

    Default SQL Server - Stored Procedures

    There is something i dont understand, if eveyone says stored procedures are so good and efficient then why not just have only stored procedures? Without any asp based sql.<BR>Ok so maybe you would need this for building dynamic queries, but other than that should all of my queries be stored procedures?

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Server - Stored Procedures

    &#062; other than that should all of my queries be stored procedures?<BR><BR>Quite probably.<BR><BR>There&#039;s not a heluva lot of advantage in using a SP when you need to pass in a list of values, such as in<BR> SELECT ... WHERE someField IN ([hl="yellow"]&#039;john&#039;,&#039;henry&#039;,&#039;robert&#0 39;[/hl])<BR>since you&#039;ll end up having to do an EXECUTE on the query, anyway. But for most simpler queries...or for the truly complex ones... Yeah, why not always an SP?<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts