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.
What are different transaction levels in SQL SERVER? The Transaction Isolation level decides how is the one process isolated from theother process. Using the transaction levels
im retrieving the path of image from the database i want to get the image in that path to be displayed in my datagridviewvolumn
Generate Function to Create Signed_Body for Instagram Project Description: I want the exact Signed_Body for Instagram The only difference is that I want the most recent ve
Project Description: I am seeking a serious and motivated software developer that can create for me software like scanspeeder with all the functions as it has. Only thing that I
Project Description: The website should be CMS based; coding done only on ASP, MySql databases, .net script, aspx and java use with least of the flash work. We will be sharing j
What is the difference between dynamic and var data types? The difference among the var and dynamic data types is that the var data type is strongly type checked at the compile
i am working on an project and my client needs it in 2 days.project is ready but don''t know how to make setup project including local sql database(.mdf) included in setup..
What is Thread.Join() in threading? There are 2 versions of Thread.Join :- Thread.join(). Thread.join(Integer) this returns a Boolean value. The Thread.Join
What is ACID fundamental? What are transactions in SQL SERVER? The transaction is a sequence of operations performed as a single logical unit of work..The logical unit of work
Explain the elements of a collaboration diagram. Classifier Role: - It only classifies a role. Association Role: - It shows the relation b/w two classifier roles.
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: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd