This is my db
how to Write stored procedure for edit when im taking identity column pls help me
create table mytable(id int identity(1,1),fname varchar(55),lname varchar(55),mobno bigint,Email varchar(100),salary money) create procedure sp_GridData as begin select * from mytable end create procedure sp_Insert ( @fname varchar(55),@lname varchar(55),@mobno bigint,@Email varchar(100),@salary money ) as begin insert into mytable values(@fname,@lname,@mobno,@Email,@salary) end create procedure sp_Edit ( @fname varchar(55),@lname varchar(55),@mobno bigint,@Email varchar(100),@salary money ) update mytable set fname=@fname,lname=@lname,mobno=@mobno,Email=@Email,salary=@salary (Here How To Write Where Condition ) end
And also how to write sp for delete