| Re: Stored Procedure Problems [message #36857] |
Fri, 28 December 2001 02:33 |
Satish Shrikhande
Messages: 167
Registered: October 2001
|
Senior Member |
|
|
You create a notepad and save it as a filename.sql and don't forget to select All Files from Save as Type .
And from sql prompt
SQL>@<path><filename>
And if you need to fire any DDL statement through procedure then you will have to go for Dynamic SQL . I hoep this will solve your problem .
Actually we have DB in Oracle and i am getting too many problems in converting the DB in SQL SERVER , not at programming level but at Administration .Do you know any message board for SQL Server .
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
