Have a look at this example:
CREATE TABLE #tblACC (siteid INT, p_id INT, descr VARCHAR(30), code INT)
DECLARE @curcount INT
DECLARE @code INT
SET @curcount = 0
SET @code = 10
WHILE(@curcount<@code)
BEGIN
INSERT INTO #tblACC (siteid, p_id, descr, code)
VALUES(11, 1, 'test' + CONVERT(VARCHAR(30), @curcount), 22)
SET @curcount = @curcount + 1
END
SET @curcount = 0
SELECT @code =COUNT(code) from #tblACC
WHILE(@curcount<@code)
BEGIN
SET @curcount = @curcount + 1
UPDATE #tblACC SET siteid = CONVERT(INT, 10 + @curcount) WHERE descr = 'test' + CONVERT(VARCHAR(10), @curcount)
END
SELECT *
FROM #tblAcc
DROP TABLE #tblACC