Posted Fri, 28 Aug 2015 14:21:53 GMT by Portal Admin

sqlcmd -i C:\MyFolder\MyScript.sql -o C:\MyFolder\MyOutput.txt

  Inside the MyScript.sql is this code.

 

          USE [yourDatabase]

          GO

 

          SELECT     IndividualId, FirstName, LastName, DateCreated

          FROM         Individual

          ORDER BY LastName

          GO

 

 

OR YOU CAN USE THIS

 

USE [yourDatabase]

GO

execute dbo.Individual

GO

You must be signed in to post in this forum.