How to build multi record INSERT and UPDATE SQL query with MS Excel



The video shows how to use Microsft Excel to prepare / build / construct SQL INSERT and UPDATE query / queries for multi / many records / rows of data. It can be especially useful for UPDATE clause queries because INSERT type has alternatives methods in provided SQL tools. It also demostartes the general usage of method to multi build queries with the usage of concatenate function.

More examples on:

http://www.excel.sos.pl

Tags:
MS SQL, My SQL, MS Excel, Oracle

1 thought on “How to build multi record INSERT and UPDATE SQL query with MS Excel

Leave a Reply

Your email address will not be published. Required fields are marked *