|
Search:
Advanced search
|
Browse by category:
|
Glossary | Contact Us |
Is there an easy way to loop through every stored procedure in a database and create a file containing all of the SP code? |
||||
By joining sysobject and syscomments table
we can get your desired results,
run this query in Query Analyzer (with result in text mode).... ----------------------------------------------------------------------------- SELECT dbo.syscomments.text, dbo.sysobjects.name FROM dbo.syscomments INNER JOIN dbo.sysobjects ON dbo.syscomments.id = dbo.sysobjects.id WHERE (dbo.sysobjects.xtype = 'p') ----------------------------------------------------------------------------- |
||||
Comments
|
31 Dec, 1969
|
Guest
|
|
sql server 2008 r2 download |
|
31 Dec, 1969
|
Guest
|
|
database designer |
|
31 Dec, 1969
|
Guest
|
|
sql tutor |
|
31 Dec, 1969
|
Guest
|
|
sql server stored procedure |
|
31 Dec, 1969
|
Guest
|
|
my fashion database |
|
31 Dec, 1969
|
Guest
|
|
database management tools |
|
31 Dec, 1969
|
Guest
|
|
photo database software |
|
31 Dec, 1969
|
Guest
|
|
php database |
|
31 Dec, 1969
|
Guest
|
|
dbms copy |
|
31 Dec, 1969
|
Guest
|
|
sql exercises |
|
31 Dec, 1969
|
Guest
|
|
web database software |
|
31 Dec, 1969
|
Guest
|
|
learning sql |
|
31 Dec, 1969
|
Guest
|
|
hosting ms sql |
|
31 Dec, 1969
|
Guest
|
|
sql database design |
|
31 Dec, 1969
|
Guest
|
|
sql query examples |
|
31 Dec, 1969
|
Guest
|
|
sql comment |
|
31 Dec, 1969
|
Guest
|
|
sql if statement |
|
31 Dec, 1969
|
Guest
|
|
sql download |
|
31 Dec, 1969
|
Guest
|
|
comic book database |
|
31 Dec, 1969
|
Guest
|
|
dbms output |
Showing: 1-20 of 34 »»
Powered by
KBPublisher (Knowledge base software)