View source for Example of executing sql script by sqlcmd

<source lang="sql">
USE AdventureWorks2012;  
GO  
SELECT p.FirstName + ' ' + p.LastName AS 'Employee Name',  
a.AddressLine1, a.AddressLine2 , a.City, a.PostalCode   
FROM Person.Person AS p   
   INNER JOIN HumanResources.Employee AS e   
        ON p.BusinessEntityID = e.BusinessEntityID  
    INNER JOIN Person.BusinessEntityAddress bea   
        ON bea.BusinessEntityID = e.BusinessEntityID  
    INNER JOIN Person.Address AS a   
        ON a.AddressID = bea.AddressID;  
GO  


</source>
sqlcmd -S myServer\instanceName -i C:\myScript.sql<br>
Or to output to a text file <br>
sqlcmd -S myServer\instanceName -i C:\myScript.sql -o C:\EmpAdds.txt<br>