Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
What are the different types of triggers in SQl
There are 2 types of triggers in the SQL server 2000 :-
1) INSTEAD OF triggers:
The INSTEAD OF triggers fire in place of the triggering action. For e.g., if an INSTEADOF UPDATE trigger exists on the Sales table and an UPDATE statement is executed against the Salestable, the UPDATE statement will not modify any row in the sales table. In spite, the UPDATE statement causes the INSTEAD OF UPDATE trigger to be executed, which might or might not modify the data in the Sales table.
2) AFTER triggers
The AFTER triggers execute the following in the SQL action, like insert, delete,or update. This is the traditional trigger that existed in the SQL SERVER. INSTEAD OF triggers gets executed automatically before the Primary Key & the Foreign Key constraints are checked, whereas the traditional AFTER triggers gets executed after these constraints are checked.
Unlike INSTEAD OF triggers, AFTER triggers can be created on views.
I need a project which shows Paypal integration with ASP.net website We have events website written in C# and ASP.net. We want to integrate Paypal using API and have a full inte
Find out circumference and area of a circle - C# Program Need Help in Assignment.
can do by using .net hadoop db is possible?
cookieless="false" timeout="20" /> Above is sample session state mode specified for SQL SERVER.
What is the main difference between sub-procedure and function? The sub-procedure is a block of multiple visual basic statements within Sub and End Sub statements. It is used t
I need help figuring out how to capture text box values from C# ASP.NET and send them from one class to another after being processed by a method.
Mention the execution process for managed code. A piece of managed code is executed as follows: Choosing a language compiler Compiling the code to MSIL Com
What is Dynamic Language Runtime (DLR)? DLR is a runtime environment that permits you to integrate dynamic languages with the Common Language Runtime (CLR) by adding a set of s
How can you use Hidden frames to cache client data? This technique is implemented by developing a Hidden frame in page which will have your data to be cached. T cols="100
Media Player App Development for Windows 8.1 platform with outstanding UI, flexible controls and simple to use. The app should be consist of 1. Normal player controls 2. s
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd