Sql file I mentioned here is just contains the set of sql queries with soem Exec statements in it. It is not a stored procedure.But it uses some variables that needs to be passed through command line. Eg : sqlcmd -S server -E -i someinput.sql -v dname='DBName' dbpath="C:\somedir" -o output.log
i want to execute this programmatically On Thu, Jun 12, 2008 at 9:49 AM, Uma Devi <[EMAIL PROTECTED]> wrote: > Hi, > I need to execute sql file through c# program.Some sql file takes some > parameters that I need to pass the variables through C# program.Is there any > way to do it.I found out that sqlcmd can be used by passing all parameters > to sql file using Process class.But I am trying to find whether we can do > this programmatically in C#. > > Please help. > Thanks, > Uma. > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups ".NetIndia" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/TechdotNetIndia?hl=en http://www.satheeshbabu.com http://www.satheeshbabu.blogspot.com/ -~----------~----~----~----~------~----~------~--~---
