Daily Archives: September 13, 2009

1 post

Passing XML data to stored procedure in SQL Server 2005

I have been working on a project recently that requires to insert a large amount of records from an Oracle database into a SQL Server 2005. I can’t use DTS to transfer the data because the data has to be extensively formatted before being inserted into the SQL Server. My initial thought was to build a long SQL query by concatenating multiple INSERT statements, then execute the query to have the records to be inserted […]