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:
[ Ссылка ]
Tags:
MS SQL, My SQL, MS Excel, Oracle
