insert后获得插入数据的编号

来源:互联网 发布:贵金属网络销售技巧 编辑:程序博客网 时间:2024/04/30 15:36
 "insert into t_memcardmaintenance (discountname,starttime,endtime," +
                                      "condition,rebate,estate) values('" +
                                      this.TextBox1.Text.Trim() + "'," + "'" + starttime + "'," + "'" +
                                      endtime + "'," + "'" + condition + "'," + "'" + this.TextBox2.Text.Trim() + "'," + "'" + 0 + "')SELECT [memberdiscountid] = scope_identity()";
原创粉丝点击