ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

More Than 10 Rows of ASP.NET Application Data table, how to save / insert in Database (Oracle 11g) in one Database Hit?

user-image
تم إضافة السؤال من قبل Muhammad Razzaq , Assistant Director IT , Punjab Education Foundation
تاريخ النشر: 2014/06/09
مستخدم محذوف‎
من قبل مستخدم محذوف‎

you can Use SQL SCRIPT wich is a set of SQL commands saved as a file in SQL Scripts. A SQL script can contain one or more SQL statements or PL/SQL blocks. You can use SQL Scripts to create, edit, view, run, and delete script files.at last in script file use commit or commitretaining for validation of all operation

http://www.bayt.com/fr/specialties/q/7217/how-to-handle-a-huge-concurrent-inserts-on-a-database-table/?feed=top_stories

 

Quresh Hatim Ali Pan wala
من قبل Quresh Hatim Ali Pan wala , senior Team Lead , Talabat.com

Save10 Records into datatable first and then Pass that datatable into stored procedure

osama Al Ansari
من قبل osama Al Ansari , Technical Delivery Manager , THIQAH Business Services

If you mean saving bulk of data, I am doing this by using Entity Framework, or you can check SqlBulkCopy class.

المزيد من الأسئلة المماثلة