The bug is that when copy pasting from sql to excel it has a tendacy to add blank spaces, carriage returns or shift columns randomly in data.
Microsoft has acknowledged the but but no fix is available yet.
The reason I looked into this is because I had to copy past 217k rows with 60+ columns onto an excel work book and i noticed that some of the data was weird looking. After serveral query runs and multiple attempts, I saw no pattern to the data movement.
you can read some of the issues here
http://social.msdn.m...?forum=sqltools
So it seems sql server 2012 has a major bug
Page 1 of 12 Replies - 2178 Views - Last Post: 03 March 2014 - 06:02 AM
Replies To: So it seems sql server 2012 has a major bug
#2
Re: So it seems sql server 2012 has a major bug
Posted 03 March 2014 - 05:27 AM
This isn't a fix but a workaround possibly:
In MS SQL Server Management Studio, go to Tools->Options->Query Results->Results to Text
I'm sure you can figure it out from there. I use this to output CSV formatted files. Excel will open a CSV as a spreadsheet.
Interesting to know about the bug. Hopefully this works though. I use 2008 still most of the time.
In MS SQL Server Management Studio, go to Tools->Options->Query Results->Results to Text
I'm sure you can figure it out from there. I use this to output CSV formatted files. Excel will open a CSV as a spreadsheet.
Interesting to know about the bug. Hopefully this works though. I use 2008 still most of the time.
#3
Re: So it seems sql server 2012 has a major bug
Posted 03 March 2014 - 06:02 AM
thanks ill give that a try and let you know if it works
Page 1 of 1