Click here to Skip to main content
15,948,155 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear All,

do we have any public & open source Java API to create Stored Procedures programatically ?

My Requirement is: I have Java class which will use such an API to create a Stored Procedure in MSSQL database with the given name.

Please let me know.

Thanks & Regards,
Abhinaw
Posted

1 solution

Since it is possible to send SQL statements to the SQL server using plain old JDBC functionality you can create any database entity you want using DDL statemens "CREATE TABLE" "CREATE PROCEDURE" etc. All you need are sufficient rights on the database.
For creating stored procedures start here in the TSQL help on MSDN: Create stored procedure[^]

Still have doubts then leave me a comment.

Best Regards,
Manfred
 
Share this answer
 
Comments
Espen Harlinn 17-Jan-11 12:45pm    
5+ Good answer
Manfred Rudolf Bihy 20-Jan-11 6:46am    
Thanks Espen!
AbhinawSachan 20-Jan-11 3:22am    
Thanks Manfred for your quick response. It really helped.
Manfred Rudolf Bihy 20-Jan-11 6:46am    
Good to hear!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900