{"id":90,"date":"2014-05-15T20:28:00","date_gmt":"2014-05-15T19:28:00","guid":{"rendered":"https:\/\/debuggersspace.com\/index.php\/2014\/05\/15\/store-procedure\/"},"modified":"2014-05-15T20:28:00","modified_gmt":"2014-05-15T19:28:00","slug":"store-procedure","status":"publish","type":"post","link":"https:\/\/debuggersspace.com\/index.php\/2014\/05\/15\/store-procedure\/","title":{"rendered":"Store Procedure?"},"content":{"rendered":"
\n
\n \t<\/i> Read Time:<\/span>1 Minute, 6 Second <\/div>\n\n <\/div>
\n
\nExample:
\nCREATE PROCEDURE dbo.QSPStudent
\n <\/span>(
\n <\/span>@option int,
\n <\/span>@id int,
\n <\/span>@name varchar(50)=null,
\n <\/span>@mobile bigint=null,
\n <\/span>@email varchar(50)=null,
\n <\/span>@password varchar(50)=null,
\n <\/span>@confirm_password varchar(50)=null
\n <\/span>)
\nAS
\nBEGIN<\/p>\n

begin
\n <\/span>if @option =1
\n <\/span>select name, mobile from student
\n <\/span>end
\n <\/span>
\n <\/span>begin
\n <\/span>if @option = 2
\n <\/span>insert into student(id,name,mobile,email,password,confirm_password)values(@id,@name,@mobile,@email,@password,@confirm_password)
\n <\/span>end
\n <\/span>
\n <\/span>begin
\n <\/span>if @option=3
\n <\/span>update student set name=@name,mobile=@mobile,email=@email,password=@password,confirm_password=@confirm_password where id=@id
\n <\/span>end
\n <\/span>
\n <\/span>begin
\n <\/span>if @option = 4
\n <\/span>delete from student where id=@id
\n <\/span>end
\nEND
\n———————————————————————————————————
\n  protected void cmdInsert_Click(object sender, EventArgs e)
\n        {
\n            if (Page.IsValid)
\n            {
\n                \/\/ GetStudentId();
\n                string str = “Exec QSPStudent 2,” + TextBox6.Text + “, ‘” + TextBox1.Text + “‘, ” + TextBox2.Text + “, ‘” + TextBox3.Text + “‘, ‘” + TextBox4.Text + “‘, ‘” + TextBox5.Text + “‘”;
\n                dm.SqlExecuteQuery(str, 100);
\n                fillGrid();
\n            }
\n            else
\n            {<\/p>\n

            }
\n        }<\/div>\n","protected":false},"excerpt":{"rendered":"

Example: CREATE PROCEDURE dbo.QSPStudent ( @option int, @id int, @name varchar(50)=null, @mobile bigint=null, @email varchar(50)=null, @password varchar(50)=null, @confirm_password varchar(50)=null ) AS BEGIN begin if @option =1 select name, mobile from student end begin if @option = 2 insert into student(id,name,mobile,email,password,confirm_password)values(@id,@name,@mobile,@email,@password,@confirm_password) end begin if @option=3 update student set name=@name,mobile=@mobile,email=@email,password=@password,confirm_password=@confirm_password where id=@id end begin if @option = […]<\/p>\n","protected":false},"author":43,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-90","post","type-post","status-publish","format-standard","hentry","category-blog"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Himanshu Namdeo","author_link":"https:\/\/debuggersspace.com\/author\/admin\/"},"uagb_comment_info":0,"uagb_excerpt":"Example: CREATE PROCEDURE dbo.QSPStudent ( @option int, @id int, @name varchar(50)=null, @mobile bigint=null, @email varchar(50)=null, @password varchar(50)=null, @confirm_password varchar(50)=null ) AS BEGIN begin if @option =1 select name, mobile from student end begin if @option = 2 insert into student(id,name,mobile,email,password,confirm_password)values(@id,@name,@mobile,@email,@password,@confirm_password) end begin if @option=3 update student set name=@name,mobile=@mobile,email=@email,password=@password,confirm_password=@confirm_password where id=@id end begin if @option =…","_links":{"self":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts\/90"}],"collection":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/users\/43"}],"replies":[{"embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/comments?post=90"}],"version-history":[{"count":0,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts\/90\/revisions"}],"wp:attachment":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/media?parent=90"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/categories?post=90"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/tags?post=90"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}