You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
47 lines
2.7 KiB
47 lines
2.7 KiB
USE [Vertragsverwaltung_20160404]
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[dt_setpropertybyid] Script Date: 02.12.2016 09:08:54 ******/
|
|
DROP PROCEDURE [dbo].[dt_setpropertybyid]
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[dt_setpropertybyid] Script Date: 02.12.2016 09:08:54 ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER OFF
|
|
GO
|
|
/*
|
|
** If the property already exists, reset the value; otherwise add property
|
|
** id -- the id in sysobjects of the object
|
|
** property -- the name of the property
|
|
** value -- the text value of the property
|
|
** lvalue -- the binary value of the property (image)
|
|
*/
|
|
create procedure [dbo].[dt_setpropertybyid]
|
|
@id int,
|
|
@property varchar(64),
|
|
@value varchar(255),
|
|
@lvalue image
|
|
as
|
|
set nocount on
|
|
declare @uvalue nvarchar(255)
|
|
set @uvalue = convert(nvarchar(255), @value)
|
|
if exists (select * from dbo.dtproperties
|
|
where objectid=@id and property=@property)
|
|
begin
|
|
--
|
|
-- bump the version count for this row as we update it
|
|
--
|
|
update dbo.dtproperties set value=@value, uvalue=@uvalue, lvalue=@lvalue, version=version+1
|
|
where objectid=@id and property=@property
|
|
end
|
|
else
|
|
begin
|
|
--
|
|
-- version count is auto-set to 0 on initial insert
|
|
--
|
|
insert dbo.dtproperties (property, objectid, value, uvalue, lvalue)
|
|
values (@property, @id, @value, @uvalue, @lvalue)
|
|
end
|
|
|
|
|
|
GO
|