Results 1 to 6 of 6

Thread: Stored Procedure

  1. Nov 4th, 2005, 10:21 PM #1
    ychhuong
    ychhuong is offline

    Thread Starter
    Addicted Member
    Join Date
    Oct 2005
    Posts
    167

    Question Stored Procedure

    I have one stored procedure in MS SQL Server.

    sp_DeleteEmployee @id INT

    I can call this stored procedure by two way.
    One is:
    VB Code:
    1. cnn.Execute "sp_DeleteEmployee " & txtID.Text
    The other used Command Objcet and Parameter, then execute the Command Object.


    Which one is better? why?
    Reply With Quote Reply With Quote
  2. Nov 5th, 2005, 08:58 AM #2
    szlamany
    szlamany is offline
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: Stored Procedure

    This was just discussed yesterday in this thread...

    http://www.vbforums.com/showthread.php?t=369262

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:     [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008
    Reply With Quote Reply With Quote
  3. Nov 5th, 2005, 11:42 AM #3
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: Stored Procedure

    And please don't name your stored procedures with an sp_ prefix.
    Reply With Quote Reply With Quote
  4. Nov 6th, 2005, 11:26 PM #4
    ychhuong
    ychhuong is offline

    Thread Starter
    Addicted Member
    Join Date
    Oct 2005
    Posts
    167

    Re: Stored Procedure

    Why shouldn't I name your stored procedures with an sp_ prefix?
    Reply With Quote Reply With Quote
  6. Nov 7th, 2005, 01:58 AM #5
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Stored Procedure

    SQL Server assumes a stored procedure with a sp_ prefix is a system stored procedure. The Master database is checked first and if the procedure exists there it will be executed. If not then the procedure in the current database is executed.
    Reply With Quote Reply With Quote
  7. Nov 7th, 2005, 07:10 AM #6
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: Stored Procedure

    Quote Originally Posted by ychhuong
    Why shouldn't I name your stored procedures with an sp_ prefix?
    You can name my SPs whatever you want, I was just giving you some advice.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width