WebJun 20, 2024 · Difference between Stored Procedure, SQL Function, and Trigger Executable Store procedure: We can execute the stored procedures when required. Function: We can call a function whenever required. Function can't be executed because a function is not in pre-compiled form. WebStored procedures can return values, but triggers cannot return values while executing them. Transaction Stored procedures allow you to use transactions such as BEGIN …
What are views, stored procedures, functions and triggers in SQL ...
WebDec 3, 2011 · A non-trigger stored procedure is like a program that has to be invoked explicitly either from code or from a scheduler or from a batch job, etc. to do its work, … WebDec 26, 2024 · A stored procedure is a group of SQL statements that is compiled one time, and then can be executed many times. Triggers are named database objects that are … bakir subasic
Ms Sql Server Developer/ssis/ssrs Developer Resume
WebResponsibilities: Wrote PL/SQL procedures, packages, triggers in Oracle 9i/10g and Oracle Forms (Developer 10g / 9i) as required. Involved in creation of databases, moved … WebUsed Database Triggers for making history of insertion, updating, deletion and all kinds of Audit routines. Created SQL objects (PL/SQL Procedures, Functions) for measuring teh employee work performance on a daily basis. Modified teh existing PL/SQL Procedures to meet teh changes of EPIC 2.0. WebDeveloped stored procedures and triggers to facilitate consistent data entry into teh database. Participated in system analysis and data modeling, which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages. Worked on concepts of Records, Collections and Dynamic SQL. bakir sahan