Click to See Complete Forum and Search --> : SQL Server Beginner


November 8th, 1999, 01:42 PM
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

Mikesc
November 8th, 1999, 02:55 PM
SQL Server@keeps track of the stored procedures. You just have to call procedures by name to get them to execute.

November 9th, 1999, 07:28 AM
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