SQL script
Table of Content
Update DB from another DB based on a field and case statement
UPDATE MyDB
SET
MyDB.AG_STATUS = CASE t2.AG_STATUS
When 'CLOSED' Then '2'
When 'OPEN' then '1'
Else '1'
End
FROM
MyDB t1
INNER JOIN SyncDB t2
ON t1.AG_NO = t2.AG_NO
Writing select result to a CSV file
sqlcmd -S server -U loginid -P password -d DBname -Q "select * from tablename" -o output.csv
Use -i options if you want to execute a SQL script like -i sql_script_filename.sql
in the *.sql file you add your query
sqlcmd -Servername\SQLEXPRESS -d MyDB -i "C:\TH_Tasks\SQLQuery.sql" -v Period = 2 -o "C:\TH_SQLexport\bokforing.csv" -h-1 -s"," -W