Convert scientific notation to text and saving in .csv file

Transact-SQL
1

Hi all,

How do I handle long number so when I convert my sql result set, I wont have the scientific notation in csv?

Thanks all

2

what are you using to produce the CSV? SSIS, C#, PoSH, Excel? The answer will depend on that.

3

Hello gbritton, I am using sql query. Thank you.

4

OK -- please post your query