External Data Import
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...