Post reply

Suggestions for strating point for VBScript and C# for use with SQL Server

  • November 30, 2009 at 9:01 am

    #206791

    Please provide some web or print suggestions for strating point for VBScript and C# for use with SQL Server.

    Thank You

    S D Khan

  • November 30, 2009 at 9:09 am

    #1085482

    You mean to write front-end apps to interface with SQL?

    If you're not familiar with the language I'd suggest a good 'beginner's guide to..' type book.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 30, 2009 at 9:13 am

    #1085485

    not for writing apps. more for understanding so that troublehsooting is easy and to use in SSIS packages.

    Thank You

  • November 30, 2009 at 9:16 am

    #1085488

    Not sure how knowing VB or C# will help in troubleshooting SQL.

    So this is for SSIS, not SQL itself? If so, I'll ask the mod to move the thread to an SSIS forum.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 30, 2009 at 4:14 pm

    #1085585

    I'll move to the SSIS forum.

    Note that you might want to still pick up a beginner's C# book. The concepts of the language will help you debug packages. You could look at this tutorial: http://www.csharphelp.com/archives2/archive402.html or this book: http://www.amazon.com/Microsoft-Programming-Absolute-Beginner/dp/1931841160

    As far as VBScript, you will need to look for tutorials like this one online: http://www.w3schools.com/Vbscript/default.asp

    There might be some books, but I'm not familiar with any.

  • December 2, 2009 at 12:36 pm

    #1086712

    You can look at the Windows Scipting Guide from MSPress for VBScript basics. Also, Don Jones has a good advanced VBScript book. That one is good because it goes over ADO objects needed in order to communicate with databases. I would say most VBScript books from Don Jones, Ed Wilson or Jeffrey Hicks would have good information in them.

    Another thing to think of is that most current and future books will be written about PowerShell, so that may be something you might want to look into...

    Joie Andrew
    "Since 1982"

  • December 2, 2009 at 6:29 pm

    #1086847

    Heh... of course most of what people use VBS and C# and Perl and... and... and... for in SSIS can many times be done in T-SQL. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply