/* Standard Insertion */
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[<INSERTPROCEDURE>]') AND type in (N'P', N'PC'))
BEGIN
	EXEC('CREATE PROCEDURE [dbo].[<INSERTPROCEDURE>] AS BEGIN SET NOCOUNT ON; END')
END

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO

ALTER PROCEDURE [dbo].[<INSERTPROCEDURE>]
(
	@ID				<SQLIDTYPE> OUTPUT
<SQLINPUTPARAMETERLIST>
)
AS

SET NOCOUNT ON

INSERT INTO
	[<TABLENAME>]
(
<COLUMNLIST>
)
VALUES
(
<SQLPARAMETERLIST>
)

SET @ID = SCOPE_IDENTITY();

SET NOCOUNT OFF

RETURN

GO


/* Standard Update */
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[<UPDATEPROCEDURE>]') AND type in (N'P', N'PC'))
BEGIN
	EXEC('CREATE PROCEDURE [dbo].[<UPDATEPROCEDURE>] AS BEGIN SET NOCOUNT ON; END')
END

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER OFF
GO

ALTER PROCEDURE [dbo].[<UPDATEPROCEDURE>]
(
	@ID				<SQLIDTYPE> 
<SQLINPUTPARAMETERLIST>
)
AS

SET NOCOUNT ON

UPDATE
	[<TABLENAME>]
SET
<SETVALUES>
WHERE
	([ID] = @ID)

SET NOCOUNT OFF

RETURN

GO

/* Standard Get-By-ID */
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[<GETPROCEDURE>]') AND type in (N'P', N'PC'))
BEGIN
	EXEC('CREATE PROCEDURE [dbo].[<GETPROCEDURE>] AS BEGIN SET NOCOUNT ON; END')
END
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[<GETPROCEDURE>]
(
	@ID			<SQLIDTYPE>
)
AS

SET NOCOUNT ON

SELECT
	[ID]
	,<COLUMNLIST>
FROM
	[<TABLENAME>]
WHERE
	([ID] = @ID)

SET NOCOUNT OFF

RETURN
GO


/* Standard Delete */
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[<DELETEPROCEDURE>]') AND type in (N'P', N'PC'))
BEGIN
	EXEC('CREATE PROCEDURE [dbo].[<DELETEPROCEDURE>] AS BEGIN SET NOCOUNT ON; END')
END

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[<DELETEPROCEDURE>]
(
	@ID			<SQLIDTYPE>
)
AS

SET NOCOUNT ON

DELETE FROM
	[<TABLENAME>]
WHERE
	([ID] = @ID)

SET NOCOUNT OFF

RETURN
GO


#$@#@
/* FK Lookup */
/*  Don't use this.  It's garbage.  */
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[<CLASSNAME>s_Get<CLASSNAME>IDsBy<FKPROPERTYNAME>]
(
	@<FKPROPERTYNAME>				<FKIDSQLTPE>
)
AS

SET NOCOUNT ON

SELECT
	[ID]
FROM 
	[<CLASSNAME>s]
WHERE
	([<FKPROPERTYNAME>] = @<FKPROPERTYNAME>)

SET NOCOUNT OFF

RETURN

599W#%44