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.
How do we connect to SQL SERVER, which namespace do we use ? The code is shown below, after that i will give the explanation for it. For this sample we will also require a SQL
What is the difference between "using System.Data;" and directly adding the reference from "Add References Dialog Box"? When you compiles a program using command line, u add th
Assignment for inheritance based on c#
Project Description: I'm presently seeking at least one more coder that will help me out manage all my concepts and in that way we will share each other's experience and make te
What is Dataset object ? The DataSet gives the basis for the disconnected storage and manipulation of the relational data. We fill it from the data store, work with it while d
Name the two properties of the GridView control that have to be specified to turn on sorting and paging. The properties of the GridView control that require to be specified to
What is an object? They are instance of classes. It is a basic unit of a system. An object is an entity that has attributes, behavior, and identity. Attributes and behavior of
What is black box testing & White box testing? The Black box testing is also termed as functional testing. It ignores how the internal functionality of a system works & depends
TSQL Function SQL Server 2012 Project Description: I require someone to prepare a TSQL function that returns the name of the ODBC DSN. I will use the queries below, to get
read a file which has emp.no,name,age as per fields/you want to calculate no.of employess whose age more than50
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