-
Here`s a fun one: Nested Stored Procedures
I have a few stored procedures of the format:
create procedure foo
yadda yadda
exec foo;5
go
create procedure foo;5
yadda yadda
go
SQL enterprise 7.0 doesn`t appear to understand sub procedures (BUG?). When I try to save or check syntax on a stored procedure like the one above I get ODBC errors. The workaround I have is that everytime I modify the stored procedure I create the separate groups/procedures at an SQL query window. Needless to say this is a messy solution, anyone know what the deal is with this? This worked flawlessly with SQL 6.5.
Anthony Kenitzki
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|