string time1 = DateTime.Now.ToString("yyyy-MM-dd ");
string time2 = DateTime.Now.AddMonths(2).ToString("yyyy-MM-dd ");
string cmdtext1 = "declare @i as int ";
cmdtext1 += "select set @i=max(id)+1 from lendrtnrec ";
cmdtext1 += "insert into lendrtnrec(id,userid,bookid,lendtime,bertntime)values(@i,"+ readerid + "','" + bookid + "','" + time1 + "','" + time2 + "')";
如上有错误,请大家帮忙看下,错在哪里?麻烦给详细代码,新手上路,多多帮助!
string time2 = DateTime.Now.AddMonths(2).ToString("yyyy-MM-dd ");
string cmdtext1 = "declare @i as int ";
cmdtext1 += "select set @i=max(id)+1 from lendrtnrec ";
cmdtext1 += "insert into lendrtnrec(id,userid,bookid,lendtime,bertntime)values(@i,"+ readerid + "','" + bookid + "','" + time1 + "','" + time2 + "')";
如上有错误,请大家帮忙看下,错在哪里?麻烦给详细代码,新手上路,多多帮助!
[LaborReportID] [int] IDENTITY(1,1) NOT NULL,
.....
========================================
select @i= (max(id)+1) from lendrtnrec
"标识"选择"是","标识种子"为1,"标识递增量"设置为1.OK
create table temptable
(
job_id smallint
IDENTITY(1,1))其中前面那个1代表从1开始,后面那个1代表新增记录时自动增1,再如:IDENTITY(10,2)代表记录从10开始,每增加一条记录就以2递增的方式向后延续。
少了一个'改为
cmdtext1 += "insert into lendrtnrec(id,userid,bookid,lendtime,bertntime)values(@i,'"+ readerid + "','" + bookid + "','" + time1 + "','" + time2 + "')";
打开表的设计,把数据类型设置为int
"标识"选择"是","标识种子"为1,"标识递增量"设置
说的对!!
我都是这样做的!