/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

8 votes208 views3 answers
Postgres database sizes
SQL
19 votes183 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
0 vote172 views1 answer
Sqlite3 not commit
SQL
3 votes184 views1 answer
Oracle limit user tablespace
SQL
0 vote231 views1 answer
Pagination with row_number
SQL
3 votes181 views1 answer
System.debug apex
SQL
-2 votes200 views1 answer
Group functions in sql
SQL
1 vote326 views3 answers
Sql subquery
SQL
1 vote190 views1 answer
Psql filed name alter
SQL
0 vote144 views1 answer
Connection error in mysql workbench
SQL