running a .sql script

Results 1 to 2 of 2

Thread: running a .sql script

  1. #1
    Join Date
    Dec 1969

    Default running a .sql script

    Hi guys.<BR>I know this might sound like a very stupid question, but please tolerate my ignorance as I am only a new kid on the block with SQL Server and similar.<BR>I am learning ASP.NET and am currently using Web Matrix (looks like a great tool for learners and it is FREE) with MSDE component that runs like a SQL Server, but it doesn&#039;t have Query Analizer or any of that great stuff which comes with the full version (costs $2000, thanks very much, but can&#039;t afford it).<BR><BR>So, anyway, I have downloaded some application examples and they all say "run this .sql script to create table, or database..."<BR>How do I do that?? Do I run it from my .aspx page or what?<BR><BR>I have tried to find an answer everywhere, but this is probably very obvious so no one bothers explaining it... If ANYONE could help, I would be very grateful! Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: running a .sql script

    open it with FSO and read it into variable strSQL<BR><BR>objConn.execute(strSQL)<BR><BR>(or the .NET equivalent)<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts