Skip to content

SELECT * INTO SQL() do not put NULL values #42

@agershun

Description

@agershun

If there are empty values in source table INTO SQL should insert NULL instead ,,.

    alasql('SELECT * INTO SQL("res.sql",{tableid:"mybase.dbo.ofline"}) \
                      FROM XLSX("hse.xlsx",{headers:true,sheetid:"New (2)"})');

in some lines generates:

    INSERT INTO mybase.dbo.ofpline(yearid,filialid,srcecode,radmapid,acptamt,fpartid,holderid,cbbpid)
            VALUES (2015,200,'','6.2.3.',3800000,25021502,,1);

See ,, at the end of the record.

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions