Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Unhappy Unanswered: Stored Procedure

    Is there a Stored Procedure utility or builder for SQL Server 2000 that works in the NT 4.0 environment????

  2. #2
    Join Date
    Feb 2003
    Location
    Milano, Italy
    Posts
    80
    mmm...sorry, but what do you mean?
    Davide Mauri
    http://www.davidemauri.it

  3. #3
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Wink Stored Procedures

    What's the best way for a novice to learn. Is the a point and click utility to use with SQL 2000 in a NT 4.0 ENVIRONMENT?

    Originally posted by manowar
    mmm...sorry, but what do you mean?

  4. #4
    Join Date
    Feb 2003
    Location
    Milano, Italy
    Posts
    80
    Use the QUERY ANALYZER TOOL + read all you can read on the sql help (formerly: Books on Line).

    With Query Analyzer you can do EVERYTHING that you do with E.M. Once you know what you're doing, you can automate and simplify the process using E.M.
    Davide Mauri
    http://www.davidemauri.it

  5. #5
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Stored Procedures

    Should indexes be include in sp that access tables with over 5000 records?

    Originally posted by manowar
    Use the QUERY ANALYZER TOOL + read all you can read on the sql help (formerly: Books on Line).

    With Query Analyzer you can do EVERYTHING that you do with E.M. Once you know what you're doing, you can automate and simplify the process using E.M.

  6. #6
    Join Date
    Feb 2003
    Location
    Milano, Italy
    Posts
    80
    Keep in mind that you don't add or include indexes on a sp, but you add it to a table and they are used automatically if they are needed.

    Of course creating GOOD indexes is always a good idea.
    Davide Mauri
    http://www.davidemauri.it

Posting Permissions

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