Sunday, 1 September 2013

spool out put to particular file from command prompt

spool out put to particular file from command prompt

i want to spool my out put to particular file .my database in sql server.i
given code in command prompt like this: first i am connecting to my data
base like this: sqlcmd -S SUPPORT2/SUPPORT2 -U sa -P solutions
SUPPORT2/SUPPORT2 is a my server name then i am giving my databse
name(vallett)
then i am taking Ename from EmployeeMaster_tbl i want to spool this out
put to particular word file how i can do this?

No comments:

Post a Comment