goodmorning,

let us assume i have a table called dbo.Info with some data, for example:

ClientID Name
111 Phil
112 Steve
113 Victor
114 Ralph
. .
. .
. .

okay, now i wanna add a new column to the table, suppose
alter Table dbo.Info
alter column Age int
go

so my question is i wanna make an insert script which insert data in Age for each Row

sth like that; Insert into dbo.info (Age) values ('25') where name = 'steve'
so i wanna insert each row by itself, how can i correct this script??

10x in advance