Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

  • RE: Parsing Parameters in a Stored Procedure

    Nice article to provide help for parsing delimited values, but I like better XML version provided by some user in the comments which is simpler but maybe more resource consuming.

    But...

  • RE: Executing a Package from Visual Basic

    Create your DTS package and save it as VB script, next open it in VS2003 or VS2005 and allow VS to convert it. After that you will have all you...

  • RE: Executing a Package from Visual Basic

    If your process is long time running process maybe you can send email to client when it is done. DTS package has this possibility or you can use SQL command...

  • RE: Eliminating Cursors

    I think that in your article the biggest difference in speed between cursor and while loop exists because of use of temporary table. Have you tried to use cursor instead...

  • RE: Using Parameters with Stored Procedures

    I think that two aspect of stored procedure are very important:

    Optimization, after you run your stored procedure for the first time it is optimized and next time it works faster because server...

Viewing 5 posts - 1 through 5 (of 5 total)