Post New Question

Database: Difference between stored procedure and trigger?

Posted By :shankey Posted Date :July 25, 2011 Points :40 Category :Others

.Stored procedure are called explicitly where as trigger are called implicitly.
.Stored procedure are not attached to specific table where as triggers are attached to specific table.
.Stored procedure are called by invoking a CALL to it where this does not applies in case of trigger.

You can also find related Interview Question to Database: Difference between stored procedure and trigger? below:

Database: State whether Trigger is a stored procedure or not?

.Yes, It is a Stored procedure that initiates an action when an event occurs. (More...)

Database: Difference between Function and stored procedure?

Function can be used in sql statements anywhere in where/select/having etc. where as stored procedure cannot be.
(More...)

What is the difference between "dynamic SQL" and "stored procedure" ?

Dynamic sql is the bunch of statements that dynamically constructed at run time and not stored in database.
Where as Stored procedures are stored in data base in complied form. (More...)

Difference between Function and Stored Procedure?

UDF can be used in the SQL statements anywhere in the WHERE/HAVING/SELECT section where as Stored procedures cannot be.
UDFs that return tables can be treated as another rowset. This can be used in JOINs with other tables.
Inline UDF's can be though of as views that take parameters and can be used in JOINs and other Rowset operations.
(More...)

What is Difference between Function and Stored Procedure?

UDF can be used in the SQL statements anywhere in the WHERE/HAVING/SELECT section where as Stored procedures cannot be. UDFs that return tables can be treated as another rowset. This can be used in JOINs with other tables. Inline UDF's can be thought of as views that take parameters and can be used in JOINs and other Rowset operations. (More...)

Database: Define Stored Procedure

.A stored proceduer is a named group of sql statements that have been previously created and stored in server database. (More...)

Database: What are the benefit of using Stored Procedure?

.Reduces network traffic
.Improve performance
.Helps to ensure integrity of database
.Once modified, available to all clients (More...)

Database: Is recursion is posible in Sql server stored procedure

Yes, Stored procedure in sql server can call itself. (More...)

What is a Stored Procedure?

Its nothing but a set of T-SQL statements combined to perform a single task of several tasks. Its basically like a Macro so when you invoke the Stored procedure, you actually run a set of statements. (More...)

Where is Cache data stored-in memory, on the hard disk, in a database, or on a state server?

The Cache object is stored in memory. (More...)

Quick Links For Interview Questions Categories:

ASP.Net	Windows Application	.NET Framework	C#	VB.Net	ADO.Net
Sql Server	SharePoint	Silverlight	OOPs	JQuery	JavaScript/VBScript
Biztalk	Patten/Practices	.IIS	WCF	WPF	WWF
Networking	Aptitude	Others	All

Find questions, FAQ's and their answers related to .NET, C#, Vb.Net, Sql Server and many more.

Now you can find lots of .NET, C#, Vb.Net, SQL Server,Windows, ASP.Net related Questions and their Answers here at www.dotnetspark.com. Our aim is to help you pass your certification Exams (MCP, MCSD, MCAD etc.,) with flying scores and get good name in your company.

So, Start looking our Interview Question section daily and improve your .NET Skills. You can also help others by posting Interview Questions and their Answers in this section.