Search the Community
Showing results for tags 'SQL Server 2008'.
i have read that when i want to store unicode characters then we have to use nvarchar as datatype and if we are storing regular type of characters then we can use varchar as datatype. i heard that collation is related with unicode characters but not knowing what is mean by collation? and how it is related with unicode characters ? when i have done sp_help tablename one of the column displays collation ----------- SQL_Latin1_General_CP1_CI_AS so please tell me this means what ?
I created a simple Stored Procedure (SP) that queries a table and renames the column names, and I'm able to push those results out to a CSV file *with* those header names when done manually.But when I try to export the results to a CSV file by running the same SP using xp_cmdshell with bcp, the header row (Col1, Col2, and Col3) does not appear in the resulting CSV file.ORIGINAL TABLE:ColumnName1-----ColumnName2-----ColumnName3Joe Schmo CustomerJane Doe CustomerTim Tiny MusicianQUERY WITHIN SP:SELECT ColumnName1 AS Col1, ColumnName2 AS Col2, ColumnName3 AS