Feeds:
Posts
Comments

Posts Tagged ‘Export using SQLCMD’

For Text File

C:\Windows\system32>SQLCMD -S your_server_name -U your_user_namae  -P your_pasword -d your_database_name  -Q “SELECT * FROM table_name” -o “C:\Users\abc\Desktop\output.txt”

For csv File

C:\Windows\system32>SQLCMD -S your_server_name -U your_user_namae  -P your_pasword -d your_database_name  -Q “SELECT * FROM table_name” -o “C:\Users\abc\Desktop\output.csv”

Advertisements

Read Full Post »

%d bloggers like this: