27,579
社区成员
发帖
与我相关
我的任务
分享
string sql = "insert into kqz_Card
(cardtime,cardtypeid,devid,devclass,imgid,imgstatus,isvalidate,modifyuser,modifytype,modifytime,faceidno,employeeid)"
[+ " values (@cardtime,@cardtypeid,@devid,@devclass,@imgid,@imgstatus,@isvalidate,@modifyuser,@modifytype,@modifytime,@faceidno,@(select employeeid from kqz_employee where kqz_employee.employeecode=:employeecode))"
+ "select @cardid=@@IDENTITY;";
、
CREATE TABLE [dbo].[Tab4](
[RowID] [INT] IDENTITY(1,1) NOT NULL,
[ID] [INT] NULL,
[Name] [NVARCHAR](50) NULL,
CONSTRAINT [PK_Tab4] PRIMARY KEY CLUSTERED
(
[RowID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
SqlCommand thisComm = thisConn.CreateCommand();
string s = "©";
thisComm.CommandText = @"INSERT INTO dbo.Tab4(ID, Name)VALUES(2,'" + s + "') select @@identity as ID";
object thisRows = thisComm.ExecuteScalar();
Console.WriteLine("RowID={0}", thisRows);