Post reply

Beginning SQL

  • September 4, 2004 at 11:23 am

    #161426

    I've been using Access to augment .Net programming for small businesses.

    Want to take advantage of stored proc's. What is a good resource for getting up to speed on using sp's and consuming return data in a C# app. Also licensing criteria for a sole proprietorship using sql server, i.e can you purchase a SQL Server license for a single user?

    Appreciate any help

    Thanks

    smj

     

  • September 7, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • September 7, 2004 at 10:35 am

    #521997

    For the programming, most C# books should show how to work with a result set. As far as stored procedures, try this: http://www.sqlservercentral.com/columnists/sburke/introductiontostoredprocedures.asp

    For licensing, you can freely redistribute MSDE for small (< 5) user groups. I think you purchase the Dev edition and then use MSDE. You can license SQL Server for one user ,but it will be the $700 or so for the standard product and $50 or so for the single CAL.

  • September 7, 2004 at 12:34 pm

    #522018

    Appreciate the answer and will check it out.

     

    Thanks

  • September 10, 2004 at 1:01 pm

    #522620

    Try _The Guru's Guide to Transact-SQL_ by Ken Henderson

    Also, more advanced

    _The Guru's guid to Sql Server Stored Procedures, XML and HTML_ by Ken Henderson.

    Both are excellent books. If you are just starting you will definitely need to read the first one before the second.

  • September 13, 2004 at 8:07 pm

    #522868

    Thanks I'll check them out!

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

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