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

my reframce

use ReportServerTempDB select *from dbo.ChunkData INNER JOIN [ChunkSegmentMapping] on ChunkSegmentMapping.ChunkId = ChunkData.ChunkID INNER JOIN [PersistedStream] on PersistedStream.SessionID = ChunkData.SnapshotDataID use ReportServerTempDB select *from dbo.Segment select *from dbo.ChunkData alter procedure selectsubquery as declare @department varchar(50) begin --select *from dbo.Segment where SegmentId = (select *from  dbo.Segment where Content= @department) select * from SegmentId where emp_add =(select *  from dbo.Segment where Content =@department) end exec selectsubquery "1" create view selectall as select *from Segment select *from selectall drop view selectall drop procedure selectsubquery create index test_index on ChunkData(SnapshotDataID) drop index ChunkData.test_index select *from dbo.Segment create database testdbset create table userse (userid int ,name varchar(50)) drop table users select * from users --insert into use...
Read more

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
Image
Login And Sign Up Using Angular js with help of local storage 1.index.html <html ng-app='LogIn'> <head>     <meta charset="utf-8">     <meta http-equiv=="X-UA-Compatible" content="IE=edge">     <meta name="viewport" content="width=device-width, initial-scale=1">     <title>LOG IN</title>     <!-- styling css -->     <link href="assets/css/bootstrap.min.css" rel="stylesheet" />     <link href="assets/css/style.css" rel="stylesheet">     <link href="assets/css/font-awesome.min.css" rel="stylesheet">     <!-- min scripts -->     <script src="assets/js/angular.min.js"></script>     <script src="assets/js/angular-route.min.js"></script>     <script src="assets/js/jquery.min.js"></script>   ...
Read more