|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
25/03/2008, 10h46
|
#1 |
Messages: n/a
Hébergeur: |
call script from another script
Hello,
Is it possible with sqlserver to call a sql script from another sql script, like @ in oracle ? Thanks, Olivier |
|
|
25/03/2008, 14h06
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: call script from another script
> Is it possible with sqlserver to call a sql script from another sql
> script, like @ in oracle ? You can call another script using ":r" in SQLCMD (or SSMS in SQLCMD mode). For example: :r C:\SqlScripts\Script1.sql -- Hope this s. Dan Guzman SQL Server MVP http://weblogs.sqlteam.com/dang/ "OD" <olivier.dubuisson@free.fr> wrote in message news:47e8bc04$0$17714$426a74cc@news.free.fr... > Hello, > > Is it possible with sqlserver to call a sql script from another sql > script, like @ in oracle ? > > Thanks, > > Olivier > |
|
|
|
26/03/2008, 16h30
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: call script from another script
Thanks, it works very well.
Is there an equivalent for sqlserver 2000 ? Olivier. "Dan Guzman" <guzmanda@nospam-online.sbcglobal.net> a écrit dans le message de news: ZU5Gj.5356$6H.4146@newssvr22.news.prodigy.net... >> Is it possible with sqlserver to call a sql script from another sql >> script, like @ in oracle ? > > You can call another script using ":r" in SQLCMD (or SSMS in SQLCMD mode). > For example: > > :r C:\SqlScripts\Script1.sql > > -- > Hope this s. > > Dan Guzman > SQL Server MVP > http://weblogs.sqlteam.com/dang/ > > "OD" <olivier.dubuisson@free.fr> wrote in message > news:47e8bc04$0$17714$426a74cc@news.free.fr... >> Hello, >> >> Is it possible with sqlserver to call a sql script from another sql >> script, like @ in oracle ? >> >> Thanks, >> >> Olivier >> > |
|
|
|
27/03/2008, 00h40
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: call script from another script
OD (olivier.dubuisson@free.fr) writes:
> Thanks, it works very well. > > Is there an equivalent for sqlserver 2000 ? As I recall, :r works in OSQL as well. And OSQL comes with SQL 2000. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx |
|
|
 |
| Outils de la discussion | |
|
|
