SQLServerCentral / Programming / Powershell / Set-based Insert from PoSh to SQL table / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 11:04:48 GMT20RE: Set-based Insert from PoSh to SQL tablehttp://www.sqlservercentral.com/Forums/Topic1304432-1351-1.aspxAnytime Man :)Wed, 04 Jul 2012 06:07:48 GMTLaerte Poltronieri Junior-367636RE: Set-based Insert from PoSh to SQL tablehttp://www.sqlservercentral.com/Forums/Topic1304432-1351-1.aspxThanks Laerte!Found you a couple of months ago, I appreciate your work.I also found these functions last week.PWed, 04 Jul 2012 06:05:44 GMTschleepRE: Set-based Insert from PoSh to SQL tablehttp://www.sqlservercentral.com/Forums/Topic1304432-1351-1.aspxUSe Chad Miller´s [url=http://poshcode.org/2116]Out-DataTable [/url] and [url=http://poshcode.org/2118]Write-DataTable[/url]it use Bulk Insert.Wed, 04 Jul 2012 05:45:36 GMTLaerte Poltronieri Junior-367636RE: Set-based Insert from PoSh to SQL tablehttp://www.sqlservercentral.com/Forums/Topic1304432-1351-1.aspxOooooohhh. Me like TVP! :-DThanks opc!Wed, 23 May 2012 08:01:01 GMTschleepRE: Set-based Insert from PoSh to SQL tablehttp://www.sqlservercentral.com/Forums/Topic1304432-1351-1.aspxAnything you can do in .NET you can do in PoSH. Lookup Table-valued Parameters, and how to use them to insert sets of data using one in a Stored Procedure. Most if not all of the examples will be in C# or VB.net, but like I said, you can port that code to PoSH. TVPs or the .NET class SqlBulkCopy are the two best ways I know of to insert batches of data from memory directly into SQL Server. If you write the data to disk that opens up all the bulk load methods of course, like bcp, BULK INSERT, SSIS, etc.Tue, 22 May 2012 13:59:32 GMTopc.threeSet-based Insert from PoSh to SQL tablehttp://www.sqlservercentral.com/Forums/Topic1304432-1351-1.aspxHi all,I've been trying to find a way to do set-based inserts into a SQL Server.As near as I can tell, there are only 2 ways:1) convert the data to be inserted to XML, pass that SQL Server, either a sproc or a file;2) export to file and BULK INSERT in SQL Server.Neither of these are especially appealing.Is there not something equivalent to $Table.Insert($NewData)Save-IntoSQLTable appears to be on the right track, but also seems to want only to work with traces.Any ideas?Tue, 22 May 2012 13:01:04 GMTschleep