Results 1 to 3 of 3

Thread: create and save stored procedure in code

  1. Feb 8th, 2005, 11:21 PM #1
    eimroda
    eimroda is offline

    Thread Starter
    Fanatic Member eimroda's Avatar
    Join Date
    Jul 2000
    Location
    Philippines
    Posts
    642

    create and save stored procedure in code

    it it possible to create/edit and save stored procedures from within vb code? im using SQL Server 2000
    On Error GoTo Hell

    Hell:
    Kill Me


    Food For Thought:

    - Do not judge a book... if you're not a judge!

    Reply With Quote Reply With Quote
  2. Feb 9th, 2005, 12:16 AM #2
    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: create and save stored procedure in code

    You'd use the objconn.execute method and create the SP just like you would in Enterprise manager, the exact same syntax.
    Reply With Quote Reply With Quote
  3. Feb 9th, 2005, 09:06 AM #3
    plenderj
    plenderj is offline
    Retired VBF Adm1nistrator plenderj's Avatar
    Join Date
    Jan 2001
    Location
    Dublin, Ireland
    Posts
    10,359

    Re: create and save stored procedure in code

    Or ExecuteNonQuery on a SQLCommand object if you're using ADO.NET...
    Microsoft MVP : Visual Developer - Visual Basic [2004-2005]
    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