 |
 |
 |
 |
|
 |
 |
Gravitybox Schedule.NET User’s Guide
Page 23
1998-2004 Gravitybox Software LLC
@address
);
SELECT
provider_guid,
name,
color,
notes,
address,
time_stamp
FROM
PROVIDER
WHERE
(provider_guid = @provider_guid)
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
The final stored procedure to modify is for update action.
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[gb_ProviderUpdate]') and OBJECTPROPERTY(id,
N'IsProcedure') = 1)
drop procedure [dbo].[gb_ProviderUpdate]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE dbo.gb_ProviderUpdate
(
@name nvarchar (50),
@notes nvarchar (1000),
@color int,
@address nvarchar (100),
@Original_provider_guid char (36),
@Original_time_stamp timestamp
)
AS
SET NOCOUNT OFF;
UPDATE
PROVIDER
SET
name = @name,
color = @color,
notes = @notes,
address = @address
WHERE
(provider_guid = @Original_provider_guid) AND
 |