Asp.net Web form CURD Operation Using Store Procedure

Store Procedure Syntax:

CREATE { PROCEDURE | PROC } [schema_name.]procedure_name
   [ @parameter [type_schema_name.] datatype 
     [ VARYING ] [ = default ] [ OUT | OUTPUT | READONLY ]
   , @parameter [type_schema_name.] datatype
     [ VARYING ] [ = default ] [ OUT | OUTPUT | READONLY ] ]

[ WITH { ENCRYPTION | RECOMPILE | EXECUTE AS Clause } ]
[ FOR REPLICATION ]

AS

BEGIN
   [declaration_section]

   executable_section

END;


schema_name


The name of the schema that owns the stored procedure.


procedure_name


The name to assign to this procedure in SQL Server.


@parameter


One or more parameters passed into the procedure.


type_schema_name


The schema that owns the data type, if applicable.


datatype


The data type for @parameter.


VARYING


It is specified for cursor parameters when the result set is an output parameter.


default


The default value to assign to @parameter.


OUT


It means that @parameter is an output parameter.


OUTPUT


It means that @parameter is an output parameter.


READONLY


It means that @parameter can not be overwritten by the stored procedure.


ENCRYPTION


It means that the source for the stored procedure will not be stored as plain text in the system views in SQL Server.


RECOMPILE


It means that a query plan will not be cached for this stored procedure.


EXECUTE AS clause


It sets the security context to execute the stored procedure.


FOR REPLICATION


It means that the stored procedure is executed only during replication.

Comments

Post a Comment

Popular posts from this blog

Angular UI Grid To Bind JSON Data

Image
1.Index.html <!doctype html> <html ng-app="app">   <head>     <script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.2.16/angular.js"></script>     <script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.2.16/angular-touch.js"></script>     <script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.2.16/angular-animate.js"></script>     <script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.2.16/angular-resource.js"></script>     <script src="http://ui-grid.info/docs/grunt-scripts/csv.js"></script>     <script src="http://ui-grid.info/docs/grunt-scripts/pdfmake.js"></script>     <script src="http://ui-grid.info/docs/grunt-scripts/vfs_fonts.js"></script>     <script src="http://ui-grid.info/release/ui-grid-unstable.js"></script>     <link rel=...
Read more

String split equal parts and reverse the string in c#

          C# Console Application:             string name;             name = Console.ReadLine();//string             int mid = name.Length / 2; //get the middle of the String             String[] parts = { name.Substring(0, mid), name.Substring(mid) };             string reverse = new string(parts[0].Reverse().ToArray());             string reverse2 = new string(parts[1].Reverse().ToArray());             Console.WriteLine(parts[0]); //first string             Console.WriteLine(parts[1]); //second string             Console.WriteLine(reverse);//frist reverse string             Console.WriteLine(reverse2);//second reverse string        ...
Read more

Difference between ASP.NET MVC and ASP.NET Web API

Image
Asp.Net Web API VS Asp.Net MVC Asp.Net MVC is used to create web applications that return's both views and data but Asp.Net Web API is used to create full blown HTTP services with easy and simple way that returns only data not view. Web API helps to build REST-ful services over the . NET Framework and it also support content-negotiation(it's about deciding the best response format data that could be acceptable by the client. it could be JSON,XML,ATOM or other formatted data),  self hosting which are not in MVC. Web API also takes care of returning data in particular format like JSON,XML or any other based upon the Accept header in the request and you don't worry about that. MVC only return data in JSON format using JsonResult. In Web API the request are mapped to the actions based on HTTP verbs but in MVC it is mapped to actions name. Asp.Net Web API is new framework and part of the core ASP.NET framework. The model binding, filters, routing and others MVC f...
Read more