列的操作

DECLARE @I int
Declare @id int
set @id=1
while @id<2365
begin
SELECT @I =(SELECT [Ac] FROM StdItems where idx=@id )/10
update StdItems set ac=@i where idx=@id
set @id=@id+1
end

2.
create procedure dbo.dt_getpropertiesbyid
 @id int,
 @property varchar(64)
as
 set nocount on

 if (@property is null) or (@property = '')
  select property, version, value, lvalue
   from dbo.dtproperties
   where  @id=objectid
 else
  select property, version, value, lvalue
   from dbo.dtproperties
   where  @id=objectid and @property=property

GO