CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Guest

    SQL Server Beginner

    I've just started to learn SQL 7. In VB with Access I used to create all SQL statements in VB code. And my last (not too big project) contains several hundreds of SQL statements. In SQL Server it's recommended to use stored procedures and call them from VB code. If in VB I can separate all statements putting them in different classes, forms, modules, then how can I keep track for all stored procedures in SQL Server. I do not see any subfolders, or the ability to create them in Stored Procedures node in Enterprise Manager. But I believe that big database can have thousands of stored procedures.
    Sorry if my question is silly.
    Vlad




  2. #2
    Join Date
    Jul 1999
    Posts
    145

    Re: SQL Server Beginner

    SQL Server@keeps track of the stored procedures. You just have to call procedures by name to get them to execute.


  3. #3
    Guest

    Re: SQL Server Beginner

    Thank you.
    I've heard something like this: "We do not have any control in our database. Each programmer used to create his own stored procedure, even if there is already several procedures which could do what programmer wants to do. It's because we have hundreds of stored procedures." If for example there were some subfolders, like DeleteProcedures, InsertProcedures and so on, it would be easier to check an existance of required one. And how many procedures can exist in a big database for a big company. 50, 750 or 50000?
    Thank you.
    Vlad


Posting Permissions

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





Click Here to Expand Forum to Full Width

Featured