As we know, MySQL have function to output its data into Text File using "Select * into outfile 'C:/mytext.txt".
Does MSSQL has "Select into Outfile" function? If yes, what is the function??
Thanks in advance :)
Anderson
Do you have access to the SQL Manager GUI? You can output to a file from that.
You can also useSQLCMD -i Input.sql -o C:\mytext.txt -e from the command prompt.
|||P.S. - I'm not positive, but I don't think you can do it directly from the SQL statement like you can in MySQL.|||You can use supplied BCP application or SQL Server Management Studio Express.
Example for BCP:
c:\Program Files\Microsoft SQL Server\90\Tools\Binn>bcp RZBWSPR.dbo.MenuItem out Result.txt -T -S DVESIC\SQLEXPRESS -c
|||You can call bcp utility with xp_cmdshell from T-SQL. Take a look at this post:http://forums.asp.net/thread/1388531.aspx
