wood burning stoves 2.0*
The moose likes JDBC and the fly likes Create Tables and stored Procedures in Microsoft SQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Create Tables and stored Procedures in Microsoft SQL" Watch "Create Tables and stored Procedures in Microsoft SQL" New topic
Author

Create Tables and stored Procedures in Microsoft SQL

navmn mn
Greenhorn

Joined: Nov 30, 2004
Posts: 13
Hi
I had created an database tables and written many stored procedures in Microsoft Sql. The server was changed, so I am accessing another server.

Now I have 2 files called "all.sql" and "tables.sql" . How do we create the previous tables and stored procedures using these 2 files.

Thanks in advance
Naveen
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Not really a JDBC question or a Java question; Query Analyzer has an "Open" option in its File menu - you could try that.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Create Tables and stored Procedures in Microsoft SQL
 
Similar Threads
where to put SQL queries ?
what are procedures in sql ?
SQL Query Problem
Connection with database Help
Database Query using Hibernate