cmd script to export a table data into utf-8 format

@echo off
set TableName=%1

call ExportDbData_Configurator_on_%computerName%.cmd

set _query="set nocount on;select * from %TableName%"
set _queryTimeOut=300

::ECHO THE RESULT
ECHO sqlcmd -S%_hostNamdAndInstance% -U%_sqlLogin% -P%_passwd% -d%_dbName% -Q%_query% -o "%_CsvDataPath%\%TableName%.csv" -s%_fieldSeparator% -u -W -w%_rowWidth% -h-1 -b -t%_queryTimeOut% -r1 1>> "%_INSTALLLOG%" 2>> "%_ERRORLOG%"



:: export a table data into TableName.csv file in unicode format , echo the input
sqlcmd -S%_hostNamdAndInstance% -U%_sqlLogin% -P%_passwd% -d%_dbName% -Q%_query% -o "%_CsvDataPath%\%TableName%.csv" -s%_fieldSeparator% -W -w%_rowWidth% -h-1 -u -b -t%_queryTimeOut% -r1 1>> "%_INSTALLLOG%" 2>> "%_ERRORLOG%"


::DEBUG PAUSE

how-to get column meta data in mssql 2005 2008

SELECT 'GET COLUMN META DATA ON MSSQL 2005 - 2008' ;

SELECT  

ROW_NUMBER() over( ORDER BY Cols.TABLE_NAME, Cols.COLUMN_NAME , Cols.ORDINAL_POSITION    ) , 

DB_NAME() as 'DbName' ,

Cols.TABLE_SCHEMA as 'TableSchema', 

Cols.TABLE_NAME as 'TableName',

Cols.COLUMN_NAME as 'ColName',

Cols.ORDINAL_POSITION as 'OrdinalPosition',

Cols.DATA_TYPE as 'DataType',

Cols.NUMERIC_PRECISION as 'NumericPrecision',

Cols.NUMERIC_SCALE as 'NumericScale', 

Cols.IS_NULLABLE as 'IsNullable',

Cols.CHARACTER_MAXIMUM_LENGTH as 'MaxLength' , 

COLUMNPROPERTY(object_id(Cols.TABLE_NAME), 

Cols.COLUMN_NAME, 'IsIdentity') AS 'IsIdentity',

( SELECT COUNT(KCU.COLUMN_NAME)

FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE KCU

INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC 

ON KCU.TABLE_NAME = TC.TABLE_NAME

AND KCU.CONSTRAINT_NAME = TC.CONSTRAINT_NAME

AND TC.CONSTRAINT_TYPE = 'PRIMARY KEY'

WHERE KCU.TABLE_NAME = Cols.TABLE_NAME

AND KCU.COLUMN_NAME = Cols.COLUMN_NAME

) AS 'IsIndex'

FROM [INFORMATION_SCHEMA].[COLUMNS] Cols

ORDER BY Cols.TABLE_NAME, Cols.COLUMN_NAME , Cols.ORDINAL_POSITION    

;