how add gender in existing table and how access from databas

Question

how add gender in existing table and how access from database in mvc view

Supreeth J · Answer

Hi In SQL Server Execute the Query as below //To Add New Coloumn Syntax: ALTER TABLE table_name ADD column_name datatype Query: ALTER TABLE EMPLOYEE ADD Gender varchar(6) //To Insert/update Value Syntax: UPDATE table_name SET column_name=value where ID in (id1id2id3...) Query: Update EMPLOYEE set Gender='Male' where EMPNO in (736974997521) Update EMPLOYEE set Gender='Female' where EMPNO in (769877887844) (736974997521) who all are Male Employees (769877887844) who all are Female Employees Call Using Model View