 |
 |
 |
 |
|
 |
 |
Gravitybox Schedule.NET User’s Guide
Page 22
1998-2004 Gravitybox Software LLC
name,
notes,
color,
address,
time_stamp
FROM
PROVIDER
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
Next you need to modify the insert, stored procedure. In the SQL statement below the
bold text indicates changes from the original procedure. The procedure takes a new
address parameter, updates the table field, and re-selects the new values for return.
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[gb_ProviderInsert]') and OBJECTPROPERTY(id,
N'IsProcedure') = 1)
drop procedure [dbo].[gb_ProviderInsert]
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE dbo.gb_ProviderInsert
(
@provider_guid char (36),
@name nvarchar (50),
@color int,
@notes nvarchar (1000),
@address nvarchar(100)
)
AS
SET NOCOUNT OFF;
INSERT INTO PROVIDER
(
provider_guid,
name,
color,
notes,
address
)
VALUES
(
@provider_guid,
@name,
@color,
@notes,
 |