-
Notifications
You must be signed in to change notification settings - Fork 0
Invoke SQLiteFill
Marco van Gaal edited this page May 19, 2015
·
12 revisions
Invoke-SQLiteFill
Bulk insert <DataTable> to SQLite Table.
WARNING: this will overwrite all Rows in table
-Connection Required? true Position? 1 Default value
Accept pipeline input? false Accept wildcard characters? false -InputObject Required? true Position? 2 Default value
Accept pipeline input? false Accept wildcard characters? false -Name Required? true Position? 3 Default value
Accept pipeline input? false Accept wildcard characters? false -Whatif [] Required? false Position? named Default value False Accept pipeline input? false Accept wildcard characters? false
None. You cannot pipe objects to Invoke-SQLiteFill.
Count of rows inserted to SQLite Table
-------------------------- EXAMPLE 1 -------------------------- C:\PS>Invoke-SQLiteFill -conn <SQLiteConnection> -InputObject <DataTable> -Name <String> Fills Table in SQLite (WARNING: this will overwrite all Rows in table) -------------------------- EXAMPLE 2 -------------------------- C:\PS>Invoke-SQLiteFill -conn <SQLiteConnection> -InputObject <DataTable> -Name <String> -WhatIf Creates SQLite transaction inserts rows and then rollsback the transaction