/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

0 vote162 views1 answer
Compare strings lexicographically in sql
SQL
4 votes129 views3 answers
Count with where
SQL
0 vote132 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
20 votes125 views4 answers
Sqlite create table if not exists
SQL
46 votes195 views4 answers
Create column sql
SQL
0 vote134 views1 answer
Sql remove first character from string
SQL
0 vote144 views1 answer
Postgresql show owner of database
SQL
2 votes132 views3 answers
Copy data from one table column to another table column in sql
SQL
1 vote132 views3 answers
Drop unique key constraint in sql server
SQL
-1 vote122 views1 answer
Pl/sql how to delete a trigger
SQL