The Simplest Question of all

4 Jul 2006 2:45 AM

Dave Johnson

Greetings,

i have a sql text file, and i dont knw how to execute it in VS.net 2005
sql express!

can anyone help!?

thanks,

Sharing makes All the Difference

--
Sent via .NET Newsgroups
http://www.dotnetnewsgroups.com

4 Jul 2006 1:57 PM

Cowboy (Gregory A. Beamer)

There are a couple of ways.

SqlCmd - the command line utility.
I don't have the syntax for running from a script, but it is the SQL Express
command line tool (actually the SQL Server 2005 command line tool)

Express Manager - Have to download
Much easier, as it is a bit more graphical

Some intro info:
http://www.yukonxml.com/chapters/mann/Express/

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************

Show quote

"Dave Johnson" <esharpco***@gmail.com> wrote in message
news:exf$fPxnGHA.1704@TK2MSFTNGP03.phx.gbl...
> Greetings,
>
> i have a sql text file, and i dont knw how to execute it in VS.net 2005
> sql express!
>
> can anyone help!?
>
> thanks,
>
> Sharing makes All the Difference
>
> --
> Sent via .NET Newsgroups
> http://www.dotnetnewsgroups.com

4 Jul 2006 4:19 PM

Cor Ligthert [MVP]

Dave,

I did not understand your question, but reading Gregory message I got the
idea, do you mean the executenonquery?

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executenonquery.aspx

I hope this helps,

Cor

Show quote

"Dave Johnson" <esharpco***@gmail.com> schreef in bericht
news:exf$fPxnGHA.1704@TK2MSFTNGP03.phx.gbl...
> Greetings,
>
> i have a sql text file, and i dont knw how to execute it in VS.net 2005
> sql express!
>
> can anyone help!?
>
> thanks,
>
> Sharing makes All the Difference
>
> --
> Sent via .NET Newsgroups
> http://www.dotnetnewsgroups.com