1、string connStr = "server = 127.0.0.1;database=Baosteel_pvs;uid=sa;pwd=123456";
2、string sql_ren = "insert into t_checkrecord(列1,列2,...) values(value1,value2,...) SELECT SCOPE_IDENTITY();";
3、 using (SqlConnection myConnection = new SqlConnection(connStr))
{
myConnection.Open();
SqlCommand myCommand = new SqlCommand(sql_ren, myConnection);
primaryKey = Convert.ToInt32(myCommand.ExecuteScalar());//主键
myConnection.Close();
myCommand.Dispose();
}
4、SCOPE_IDENTITY,IDENT_CURRENT,和 @@IDENTITY 是类似的函数,因为它们返回插入到标识列的值。
https://msdn.microsoft.com/zh-sg/library/ms190315.aspx