store procedure

CREATE DATABASE:
create database KTest
use KTest
CREATE TABLE
Create Table EntryTB(id int primary key identity(1,1), Name varchar(30),DOB nvarchar(30) , Qualification varchar(20),
Gender varchar(20), Address Varchar(100), State varchar(20), Phone bigint, Email varchar(30))
select * from EntryTB
SQL STORED PROCEDURE:
Create procedure proEntryInsUP (@id int,@name varchar(50),@DOB nvarchar(30) ,@Gender varchar(50),@Qty varchar(50),
@add varchar(50),@state varchar(50),@phone bigint,@email varchar(50),@Action varchar(50))
as
begin
if @Action='insert'
begin
insert into EntryTB(Name,DOB,Gender,Qualification,Address,State,Phone,Email)
values(@name,@DOB,@Gender,@Qty,@add,@state,@phone,@email)
end
else if @Action='update'
begin
update EntryTB set Name=@name,DOB=@DOB,Gender=@Gender,Qualification=@Qty,
Address=@add,State=@state,Phone=@phone,Email=@email where id= @id
end
else if @Action='Select'
begin
select id,Name,DOB,Gender,Qualification,Address,State,Phone,Email
from EntryTB where id= @id
end
else
select id,Name,DOB,Gender,Qualification,Address,State,Phone,Email
from EntryTB
end
Create procedure proEntryDelSelect(@id int,@Action varchar(50))
as
begin
if @Action='Delete'
begin
delete from EntryTB where id= @id
end
end

3 Replies

Know the answer? Post it — somebody with the same question will find it here.