Thank you,Sure can. Check out the osql command-line utility, which lets you run individual T-SQL statements or script files. Or, there are several tools you can use to manage MSDE:
ASP.NET Enterprise Manager, an open source SQL Server and MSDE management tool.
ASP.NET WebMatrix (which includes a database management tool) from this web site (click on the Web Matrix tab at the top of this page).
Microsoft's Web Data Administrator is a free web-based MSDE management program written using C# and ASP.NET, and includes source code.
You can also access MSDE using Access.
Don|||If I write a stored procedure and then script it, how can I use osql to run the script and add the sp to a database on the server? Can you show me an example? Do I create a cmd file that contains the script?
Thank you,|||Here's how you run a script file:
osql -E -i "myScripts.sql"
And to run a line of T-SQL directly:
osql -E -Q "DROP DATABASE pubs"
There are a gaggle of options for osql, so you'll need to look at the docs to use the ones appropriate for your setup.
Don|||Can you show me a sample of a stored procedure to add a field to a table that is already in a database?
Thanks again for your help,|||
CREATE PROCEDURE MyProc
AS
ALTER TABLE myTable ADD newCol VARCHAR(20) NULL
GO
No comments:
Post a Comment