Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Anselmo Garcia
Starting Member
2 Posts |
 Posted - 2008-05-19 : 12:27:14
|
| I'm traying to upload SP than I have in a file.In Sybase too upload with read sentence:ex: read c:\file.sql;In Oracle too upload with @ sentence:ex: @c:\file.sql;but in SQlServer I can't find it.Some body can help to me. Thanks... |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-05-19 : 13:05:59
|
You can use OSQL utility from command prompt for that.OSQL -S <server name> -U <user-name> -P <password> -i <sql-file-path> Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-19 : 13:06:32
|
| upload? where? You just need to open file and run it to create procedure on your db. |
|
|
|
Anselmo Garcia
Starting Member
2 Posts |
Posted - 2008-05-20 : 11:41:34
|
| ok here is a little description of situation...I have a system with a client, now I have new features(inclued Stored Procedures) for the system and I going to update to client, I want to do some thing automatically.When I update execute a system for many things for update, and use a sentence EXECUTE IMMEDIATE for my queries, I try to use this for create the stored procedures.Maybe you have other way to upload the stored procedures...some Idea ???? |
|
|
|
|
|
|
upload stored procedures automatically