简单的插入数据 存储过程 SCOPE

简单的插入数据 存储过程 SCOPE_IDENTITY() asp:Button ID=(temp == 0){myShare.WebMessageBox( this .Page, "留言发送失败，请重试！" );} else {Page p = (Page)System.Web.HttpContext.Current.Handler;p.ClientScript.RegisterStartupScript(p.GetType()

简单的插入数据 存储过程 SCOPE_IDENTITY()

  this.Page, "留言发送失败，网站空间，香港服务器，请重试！"); } else { Page p = (Page)System.Web.HttpContext.Current.Handler; p.ClientScript.RegisterStartupScript(p.GetType(), "提示", "<script>alert('信息发送成功！');window.location='BuyInfoList.aspx'</script>");  this.mCompany.Text = ""; this.mName.Text = ""; this.mMail.Text = ""; this.mTel.Text = ""; } }

Create proc AddGuestBooks BEGIN insert into GuestBooks(Creater,CompanyName,Contact,Email,Tel,Content) values(@Creater,@CompanyName,@Contact,@Email,@Tel,@Content) SELECT @EC_TempID=SCOPE_IDENTITY()  IF @EC_TempID=0 BEGIN SET @ReturnValue=-1 END else begin set @ReturnValue=@EC_TempID end END end go

posted on