InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 07:10:10 GMT20http://www.sqlservercentral.com/Forums/Topic527094-146-1.aspxthanks now if i have another table name empadd where i have to update at the same time and whose fields areEaddID address empid 1 abc 1 2 asd 2then what will be the changehere empid of empadd is foreign key of the table emplyeeWed, 02 Jul 2008 05:09:55 GMTpulak_mcahttp://www.sqlservercentral.com/Forums/Topic527094-146-1.aspxYes. Wed, 02 Jul 2008 04:42:33 GMTSuresh B.http://www.sqlservercentral.com/Forums/Topic527094-146-1.aspxthanks if the empid is automatically generated no then is it sameWed, 02 Jul 2008 04:28:25 GMTpulak_mcahttp://www.sqlservercentral.com/Forums/Topic527094-146-1.aspxExample:[code]create procedure spEmployeeUpdate(@EmpId integer,@Name char(75),@Salary decimal(8, 2))asupdate employee set [name] = @Name, Salary = @Salary where empid = @EmpId[/code]Wed, 02 Jul 2008 04:12:40 GMTSuresh B.http://www.sqlservercentral.com/Forums/Topic527094-146-1.aspxHow can i write a store procedure in sql server to update a particular row of a table. For Example i have a table name Emplyee which have column empid ,name ,salary. Now the data are asempid name salary 1 a 1000 2 b 2000so how can i update the row of empid of 2Wed, 02 Jul 2008 02:34:13 GMTpulak_mca