SQLtoExcel

SQLtoExcel copied to clipboard

Executing for a huge table (1 million records) will got the following error: a1.sql System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown. at DocumentFormat.OpenXml.EnumInfoLookup`1.EnumStringLookupImpl.IsDefined(TEnum value, Int32& index) at DocumentFormat.OpenXml.EnumInfoLookup`1.EnumStringLookupImpl.Lookup(TEnum value) at...

colin08

SQLtoExcel can't handle sql script files with multiple result sets

1

Executing a stored proc with multiple result sets throws a duplicate exception. suggested fix: // Program.cs `dtCopy.TableName = GetTableName(fi.Name.Replace(fi.Extension, ""));` ... ``` private static HashSet _sheetnames = new HashSet(); private...

veenvlietm