Tags Database Programming C Sharp

Animals & Plants Arts & Entertainment Auto Beauty & Health Books and Literature Business Electronics Engineering & Technology Food & Drink History Hobbies Jobs & Education Law & Government Math People & Society Science Social Studies Sports Travel & Places

0

Subjects>Science>Engineering

Can You Write Trigger in Stored Procedures?

Anonymous

∙ 15y ago

Updated: 10/24/2022

A trigger is a stored procedure. It is a special stored procedure that runs in response to some defined event, such as an insert into a table.

Wiki User

∙ 15y ago

Still curious? Ask our experts.

Chat with our AI personalities

Fran

I've made my fair share of mistakes, and if I can help you avoid a few, I'd sure like to try.

Chat with Fran

Jordan

Looking for a career mentor? I've seen my fair share of shake-ups.

Chat with Jordan

Taiga

Every great hero faces trials, and you—yes, YOU—are no exception!

Chat with Taiga

Add your answer:

Earn +20 pts

Q: Can You Write Trigger in Stored Procedures?

Write your answer...

Submit

Still have questions?

imp

Continue Learning about Engineering

Can we use javascript in SQL stored procedure?

Transact-SQL in an internationally standardised method to create, modify and delete databases and tables, as well as insert, retrieve, modify and delete data stored in a database. With Microsoft SQL Server 2005 you can also author procedures in any managed language such as C# or VB. This is because it is integrated with the CLR which allows you write powerful programs inside stored procedures. All functionality of the .NET Framework BCL (Base Class Library) is available to your stored procedures. This means that developers have access to thousands of pre-built classes and routines which can be accessed. The BCL includes classes that provide functionality for improved string functioning, advanced math operations, file access, cryptography, and more.

What are the procedures used to identify and address surplus or missing equipment or resource?

write it down

What is Upper trigger point in schmitt trigger?

the point of input voltage at which Q1 begins to conduct

What are stored in heap memory?

Objects are stored in heap.

How do you use a shotgun?

Pull the trigger

Trending Questions

Can transient variables be declared as 'final' or 'static'? Spalling in a boiler reters to? Why is analogy important in technical writing? Which metal has the highest conductivity? What does a hot water flow restricter do in a combi? What is the Kannada word for 'steel'? What are the applications of dc compound motors? What is the use of micrometer? What is a bistellar flip? How many rubber bands are in a confetti criss cross? Explain the construction and working of a dry cell? What do you call a scientist that studies technology? What are the problems of the bottom-up budgeting approach? What is the equivalent ISO standard of IS-2102-1993? What is excess voltage? When Exception has been thrown by the target of an invocation? Does a start capacitor control speed? Is a lintel the same as a header? What do you call a person who cleans a drain? What is zero pcb?

Related Questions

What is trigger in DBMS?

A trigger is a special kind of stored procedures that automatically executes when an event occurs in the database server. Insert, update and delete are called as events.

What is Trigger is SQL Server 2005?

A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are stored in and managed by the DBMS.Triggers are used to maintain the referential integrity of data by changing the data in a systematic fashion. A trigger cannot be called or executed; the DBMS automatically fires the trigger as a result of a data modification to the associated table. Triggers can be viewed as similar to stored procedures in that both consist of procedural logic that is stored at the database level. Stored procedures, however, are not event-drive and are not attached to a specific table as triggers are. Stored procedures are explicitly executed by invoking a CALL to the procedure while triggers are implicitly executed. In addition, triggers can also execute stored procedures.Nested Trigger: A trigger can also contain INSERT, UPDATE and DELETE logic within itself, so when the trigger is fired because of data modification it can also cause another data modification, thereby firing another trigger. A trigger that contains data modification logic within itself is called a nested trigger.

What is Advantages and disadvantages of stored procedures?

1> Poor Exception handling 2>There are no debuggers available for stored procedures Siva.Pachigolla

What is the examples of Stored procedure?

sp_helpdb , sp_who2, sp_renamedb are a set of system defined stored procedures. We can also have user defined stored procedures which can be called in similar way.

What are stored-procedures?

It is a saved set of SQL commands that can be run by the user.

What is mean by trigger?

it s an stored procedures....it s an statements..that goes into effect when you modify data in a specified table using one or more data modification operations: UPDATE, INSERT,or DELETE.a trigger is a set of Structured Query Language (SQL) statements that automatically "fires off" an action when a specific operation, such as changing data in a table, occurs.

What are stored procedures in data bases?

Stored procedure is the pl-sql block in precomplile from and can be used to excecute plsql statement

Which of these procedures usually has a set time during which to write?

Free write

What risks are associated with electroencephalography?

Being off certain medications for one to two days may trigger seizures. Certain procedures used during EEG may trigger seizures in persons with epilepsy. Those procedures include flashing lights and deep breathing.

What are the procedures in rdbms?

Procedures in an RDBMS are programs that are written to accomplish a set of functions that cannot be done using a single query. A procedure contains a sequence of SQL Queries that can be executed one after the other by invoking the procedure. There are two kinds of procedures Functions & Stored Procedures.

What is the difference between a stored database procedure and a batch of SQL statements submitted by a client application?

Stored procedures prevent unauthorized access to data

What is the name of the SQL language used in SQL Server stored procedures?

Transact SQL (TSQL)

Still have questions?

imp

Resources

Top Categories

Product

Company

Copyright ©2025 Infospace Holdings LLC, A System1 Company. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.