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

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

متابعة

What a stored procedure in Sql Server??

user-image
تم إضافة السؤال من قبل Wassim Helal , Formateur , Ministère du tourisme
تاريخ النشر: 2014/05/20
Abdullah Abdurrahman
من قبل Abdullah Abdurrahman , Software Development Manager , Global Computer Services

Its a prepared SQL Statement that you save before, then you can call this procedure over and over,you can call this procedure from even the SQL Server Console, or from Programming Language using SQLClient, or making the Procedure itself runs periodically or under event.

jagtarsingh leedar
من قبل jagtarsingh leedar , Assistant Manager IT , Servify

A stored procedure is nothing more than prepared SQL code that you save so you can reuse the code over and over again.  So if you think about a query that you write over and over again, instead of having to write that query each time you would save it as a stored procedure and then just call the stored procedure to execute the SQL code that you saved as part of the stored procedure.

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