/SQL/How to input data as id in database sql c#

How to input data as id in database sql c#

    using(SqlCommand cmd=new SqlCommand("INSERT INTO Mem_Basic(Mem_Na,Mem_Occ) output INSERTED.ID VALUES(@na,@occ)",con))
    {
        cmd.Parameters.AddWithValue("@na", Mem_NA);
        cmd.Parameters.AddWithValue("@occ", Mem_Occ);
        con.Open();

        int modified =(int)cmd.ExecuteScalar();

        if (con.State == System.Data.ConnectionState.Open) 
            con.Close();

        return modified;
    }
}

Source: stackoverflow.com

Similar codes

4 votes330 views1 answer
Adding data to table in sql python
SQL
1 vote404 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
0 vote318 views1 answer
How to reset AI in sql
SQL
2 votes349 views2 answers
How to run postgresql in linux
SQL
0 vote331 views1 answer
Java input type sql date
SQL
0 vote355 views1 answer
Oracle plsql sleep
SQL
0 vote350 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote345 views1 answer
Plpgsql raise notice
SQL
0 vote343 views1 answer
Allow external access to mysql
SQL
0 vote377 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL