Stored Procedure CURD Operation

Table Creation:
 -->CREATE TABLE User
 (  
  Id INT primary key NOT NULL,
  Name VARCHAR(50) NOT NULL,
  Email_id VARCHAR(50)NOT NUL
  ); 


 1.Table To Insert The data

CREATE PROCEDURE [dbo].[InsertUser]
(
  @ID int,
 @Name varchar(50),
 @Email_id varchar(50)
)
AS
Begin
insert into User(Id,Name,Email_id)values(@Id,@Name,@Email_id)
END

2.Table To Delete The data

CREATE PROCEDURE [dbo].[delete_all]
(@ID INT)
AS
BEGIN
      delete from   User where ID = @ID
END

3.Table To Select The data

ALTER PROCEDURE [dbo].[select_all]
AS
BEGIN

SELECT *
FROM [dbo].[User]
END 

4.Table To Select By Id The data

ALTER PROCEDURE [dbo].[SelectById](@ID INT)
AS
BEGIN
      SELECT * FROM User WHERE ID = @ID
END

 5.Table To Update Id The data

ALTER PROCEDURE [dbo].[update_all]
(@ID INT,@name varchar(50))
AS
BEGIN
      UPDATE  Userset ID = @ID,name=@name
END
5. Sub Queries to get the data 

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

Web api to jquery call

function GetAllContacts() {             $.ajax({                 url: 'api/ContactsAPI',                 type: 'GET',                 dataType: 'json',                 success: function (data) {                     BindContacts(data);                 },                 error: function (error) {                     debugger;                     alert('Error Loading Contacts');                 }             });         }         function GetContactForEd...
Read more