External Data Import

Published: 02 March 2020
on channel: Database Knowledge
271
8

SQL Server Tutorial by : Hosam Abbas
Use SSIS SQL-Server Integration services, Import export wizard
Create Stored Procedure.
Use CURSOR
Use @@FETCH_STATUS , @@TRANCOUNT
Use TRY CATCH.
USE SQL-Server Transactions (Begin, Commit, Rollback).
Handling Errors.
Manipulate data across related tables.
=============================
Question by : Mr. Hassan Eladawi
How to import contacts data from external sources (example: excel, access) to SQL-Server database by using the same method : TRY .. CATCH?
Scripts (Google Drive):
https://drive.google.com/open?id=1u-N...


On this page of the site you can watch the video online External Data Import with a duration of hours minute second in good quality, which was uploaded by the user Database Knowledge 02 March 2020, share the link with friends and acquaintances, this video has already been watched 271 times on youtube and it was liked by 8 viewers. Enjoy your viewing!