IF EXISTS ( SELECT 1 FROM dbo.sysobjects WHERE id = object_id(N'[$GetSingleProcName$]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
|
DROP PROCEDURE [$GetSingleProcName$]
|
GO
|
------------------------------------
|
--ÓÃ;£ºµÃµ½Ò»¸ö$ChinaComment$ʵÌå
|
--˵Ã÷£º
|
--×÷Õß: $Author$
|
--ʱ¼ä£º$CurDate$
|
------------------------------------
|
CREATE PROCEDURE $GetSingleProcName$
|
@$Primary$ $DataType$
|
AS
|
SET nocount ON;
|
|
SELECT $strQueryCol$
|
FROM $TableName$ AS $TableAlias$ WITH(NOLOCK) WHERE $Primary$=@$Primary$
|
|
SET nocount OFF;
|
GO
|
