Differance between Stored Procedure & User define functiona(UDF)

By -
Stored Procedure1) If error occurred then execute next statement.
2) Use EXECUTE or EXEC to run.3) Can return values not mandatory.
4) SP can not be called from UDF.
5) Have transaction.
6) Can use XML FROM Clause.

UDF1) If error occurred then can not execute next statement.
2) Execute from sql SELECT or SQL action queries.
3) Must return 1 Value or table.
4) UDF can be called from SP.
5) Don't have transaction because don't have DML queries.
6) Can't use XML FROM Clause.

Comments

Post a Comment

Popular posts from this blog

How to get motherboard serial number, Processor ID, VolumeSerialNumber using C#?

By -
Add using System.Management; namespace in your application then //Get motherboard's serial number ManagementObjectSearcher mbs = new ManagementObjectSearcher("Select * From Win32_BaseBoard"); foreach (ManagementObject mo in mbs.Get()) { textBox1.Text = mo["SerialNumber"].ToString(); } //Get Processor's Identity mbs = new ManagementObjectSearcher("Select * From Win32_processor"); foreach (ManagementObject mo in mbs.Get()) { textBox2.Text = mo["ProcessorID"].ToString(); } //Get Network Adapter Configuration mbs = new ManagementObjectSearcher("Select * From Win32_NetworkAdapterConfiguration"); foreach (ManagementObject mo in mbs.Get()) { textBox3.Text = mo["MACAddress"].ToString(); break; }
Read more

Fiserv Interview Questions.

By -
1) For edit functionality in DataGird specify Column name 2) Why you may not want to use Paging funtionality in data grid 3) Function of SqlCommanBuilder in code. 4) Find the error in code . Its related to database connection. I think that connection sould be closed in finally instead of try. 5) What is the relation between src='' & Inherits='' in <@ Page > directive 6) What is derective in the user control page & its extention of file 7) Question related to 404 error code Error page & Default error page. 8) Its related to Autherization in web config related to folders 9) Related to definition 10) not remembred with question but answer is cookiless = true related question 11) Page is posting the 2 times why is it so 1) user control load 2) some control call load 12) describe !Page.PostBack Select Options 13) Question related to Session mode = SQLServer 14) Some question related to validation control - compare validator 15) Some question
Read more

AngularJs - Simple Example

By -
In Angular "-" is used because HTML specification says that anything with - will not be parsed by HTML. Means If you will use - in element naming then other needs to parse it. So in thins case Angular will parse elements. $scope - Is a Angular Service for a scope management. As per the following code, Each ng-controller scope is different. $scope is parameter for your function and angular will inject $scope object into your function. $rootScope - Application have only one rootScope and which is global. This code will create object of customer class  and this controller will have his scope under that scope he do have access to Customer Name and Customer Code.  <div  ng-controller ="customerObj">  $scope.$watch ("CustomerAmount", function() - This is the customer watch code ng-App - In one HTML file you can have only one ng-app. ::  is considered a one-time expression. One-time expressions will stop recalculating once they are stable,
Read more