How can i access to sql server from windows batch

I want to conne开发者_开发知识库ct to Sql server and running some sql queries. How can i do that? Thank you for helps..

Check out the SQLCMD utility:

http://msdn.microsoft.com/en-us/library/ms165702.aspx

Works not only on SQL Server 2008 Express, but also on the full versions, too.

You really need more detail in your question.

Based on my most common experiences, though, if you're just running some queries and putting the results somewhere, you'd want to create a SSIS (SQL 2k5 or 2k8) or DTS (SQL 2k5 and before) package and either have Windows schedule call the package or call it through your .bat file.