/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 vote138 views1 answer
Convert LDAP Epoch to Date
SQL
6 votes130 views2 answers
Oracle trigger
SQL
0 vote118 views1 answer
Mysql add to number
SQL
0 vote143 views1 answer
Having all mysql
SQL
4 votes114 views2 answers
Sql server date now
SQL
1 vote120 views1 answer
Postgres first_value in gropby
SQL
3 votes112 views1 answer
Oracle apex warning message
SQL
0 vote118 views1 answer
Import sql inside hide sql
SQL
0 vote114 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
6 votes113 views1 answer
Rank function in oracle with example
SQL