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