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