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 is the difference between Stored Procedure (SP) and User Defined Function (UDF)?
Some of major differences between a stored procedure and user defined are as follows:-
1. The UDF can be executed by using the "SELECT" clause while SP's can not be.
2. The UDF cannot be used in the XML FOR clause while the SP's can be used.
3. The UDF does not return any output parameters while the SP's return output parameters.
4. If there is an error in the UDF its stops executing. But in SP's it just ignores the error and moves to the next statement.
5. The UDF cannot make permanent changes to the server environments while SP's can
6. Change some of the server environment.
What's difference between "Optimistic" and "Pessimistic" locking? In the pessimistic locking when user wants to update a data it locks the record and till then no one can updat
Briefly explain what user controls are and what server controls are and the differences among the two. An ASP.NET control (sometimes known as a server control) is a server-si
Question: (a) The ObjectDataSource control is an alternative design approach to using AccessDataSource or SqlDataSource controls. Explain and illustrate how an ObjectDataSourc
#queWrite a XML with database with book details (BOOK ID, Title, Author, subject, published Year, language, vendor, price)stion..
Here's the General Background on our project work: We need your help building out a new application that's part of a new startup in the Silicon Valley. We've built a fairly s
Question : (a) Explain fully how ADO.NET functions. Illustrate your answer using a diagram. (b) List and explain three methods of the SqlCommand class. (c) Give four o
Inventory billing and Management application in .net Project Description: Digital Inventory management Main Features Multi user User friendly windows based s
Question: (a) Using the help of a diagram, describe the layer of the .NET framework that sits between Visual Basic.NET 2005 and the operating system. (b) Explain the charac
What is semantic gap? Defining a useful channel includes both understanding the applications requirements and recognizing the limitations of the underlying technology. The gap
What is the difference between the Select clause and SelectMany() method in LINQ? Both the Select clause and SelectMany() method are used to produce a result value from a sourc
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