If you have access to an SQL Development program (such as Sql Server Management Studio) you should author your SQL Command there and try them out. And pay attention to the intellisense and highlighting that it applies.
UPDATES @Entry
SET Name = @names
, Father Name = @fathername
, Gender = @gender
, CNIC = @cnic
, Mobile = @mobile
, Date of Birth = @birthdate
, Address = @address
, Village Council = @vc
, Tehsil = @tehsil
, District = @district
, occupation = @occupation
where (Serial No = @serialno)
1. It should be UPDATE as previously noted
2. Name is a "special" word
3. Space in column name, should be wrapped [Father Name]
4. Date is a data type, space in column name
5. Address is a "special" word
6. Both Serial and No are special words
My rules of development...
1. If a column name or variable changes colors when I type, I change that items name
2. No spaces in column names (or variables)
3. Use a SQL IDE when developing a query for writing and testing