SQL表非自增字段自增存储过程

CREATE PROCEDURE uspTest
AS
	DECLARE @C1 varchar(10)

	BEGIN
    SELECT @C1= t1_c1 FROM t1;
	SET @C1=@C1+1;
	if(@C1>9999)
		BEGIN
		SET @C1=1;
		END
	UPDATE t1 SET t1_c1 = @C1
	RETURN @C1
	END
GO