Professional Web Applications Themes

SQL-DMO and stored procedures - Microsoft SQL / MS SQL Server

Hi, is that possible to call a stored procedure through SQL-DMO? cheers p...

  1. #1

    Default SQL-DMO and stored procedures

    Hi,

    is that possible to call a stored procedure through SQL-DMO?

    cheers
    p




    Guest

  2. #2

    Default Re: SQL-DMO and stored procedures


    <pl> wrote in message news:phx.gbl... 

    It is possible. Look for ExecuteImmediate method of Database object


    --
    Regards,
    Tomislav Kralj
    tel.hr


    Tomislav Guest

  3. #3

    Default Re: SQL-DMO and stored procedures

    thanks, but how could I pass parameters into sp?

    "Tomislav Kralj" <tel.hr> wrote in message
    news:#phx.gbl... 
    news:phx.gbl... 
    >
    > It is possible. Look for ExecuteImmediate method of Database object
    >
    >
    > --
    > Regards,
    > Tomislav Kralj
    > tel.hr
    >
    >[/ref]


    Guest

  4. #4

    Default Re: SQL-DMO and stored procedures

    I guess

    Database.ExecuteImmediate "proc_name 1235"

    --
    Regards,

    Tomislav Kralj
    tel.hr

    <pl> wrote in message news:eyi#phx.gbl... 
    > news:phx.gbl... 
    > >
    > > It is possible. Look for ExecuteImmediate method of Database object
    > >
    > >
    > > --
    > > Regards,
    > > Tomislav Kralj
    > > tel.hr
    > >
    > >[/ref]
    >
    >[/ref]


    Tomislav Guest

Similar Threads

  1. dt_ Stored Procedures
    By chopper in forum ASP Database
    Replies: 2
    Last Post: July 20th, 04:06 PM
  2. New to ASP and Stored Procedures
    By John Berman in forum ASP Database
    Replies: 6
    Last Post: February 28th, 01:37 AM
  3. Stored Procedures and 4GL
    By Ahmer Sajjad in forum Informix
    Replies: 1
    Last Post: September 9th, 01:23 PM
  4. Stored Procedures
    By Vladi in forum Microsoft SQL / MS SQL Server
    Replies: 9
    Last Post: August 13th, 01:52 PM
  5. Need help about stored procedures
    By Tahir in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 23rd, 10:17 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139