The object-scripting tag has no wiki summary.
1
vote
2answers
205 views
ORM-style server-side programming languages (OO replacement for PL/SQL?)
Good evening,
Is there an Object Oriented replacement for PL/SQL, allowing server side procedures to be written [and then called client or server side]?
(for MySQL, PostgreSQL, Oracle or etc.)
0
votes
1answer
181 views
SQL Server - Must be first statement in query batch - what and why?
I cannot find a list of type of objects that while being created the command must be the first statement in query batch. So far I ve found that function/stored_procedure/view must be the first.
Does ...
0
votes
2answers
100 views
Auto Script DB Objects for SVN
My Boss requires that we keep up to date scripts of all database objects in svn. This results in constantly trying to find the object in the current script and copy and pasting the changes.
Is there ...
1
vote
2answers
791 views
How can can I get object definitions stripped of all comments?
When I want to know if a stored procedure or views references a given name (table, view or column), I need a version of the object definition stripped of all comments.
Is this possible by a SQL ...
5
votes
2answers
795 views
How can I detect broken stored procedures after a schema change?
I've modified a central table in my database, and sp_depends literally returns hundreds of results, and I'm concerned some of those stored-procedures might not compile anymore after my change.
...
1
vote
1answer
941 views
Automated UML2 Class Diagram generation from SQL?
How can I generate a class diagram from an SQL database or script? I'll add the functions and set whether the attributes are public, private or virtual once the initial diagram is generated.
I've ...
