20 lines
483 B
Plaintext
20 lines
483 B
Plaintext
|
CREATE PROCEDURE [dbo].[sp_DefaultPropertiesInsert]
|
||
|
|
@PropertyId int
|
||
|
|
,@PropertyName nvarchar(max)
|
||
|
|
,@DefaultValue nvarchar(max)
|
||
|
|
,@errorNumber int output
|
||
|
|
,@errorMessage nvarchar(250) output
|
||
|
|
AS
|
||
|
|
BEGIN
|
||
|
|
set @errorNumber = 0; set @errorMessage = space(0);
|
||
|
|
|
||
|
|
insert into [dbo].[DefaultProperties]
|
||
|
|
([PropertyId]
|
||
|
|
,[PropertyName]
|
||
|
|
,[DefaultValue])
|
||
|
|
values
|
||
|
|
(@PropertyId
|
||
|
|
,@PropertyName
|
||
|
|
,@DefaultValue)
|
||
|
|
END
|