IF EXISTS ( SELECT 1 FROM dbo.sysobjects WHERE id = object_id(N'[$GetListProcName$]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
  DROP PROCEDURE [$GetListProcName$]
GO
------------------------------------
--ÓÃ;£º»ñµÃ$ChinaComment$Êý¾ÝÁбí
--˵Ã÷£º
--×÷Õß: $Author$
--ʱ¼ä£º$CurDate$
------------------------------------
CREATE PROCEDURE $GetListProcName$
	@strWhere nvarchar(500) -- ²éѯÌõ¼þ
AS 
  DECLARE @strQueryCol nvarchar(max),
          @strSql nvarchar(max)
         

  SET nocount ON;

  SET @strQueryCol=' $strQueryCol$ '
 
  SET @strSql= ' SELECT '+@strQueryCol
              +' FROM $TableName$  AS $TableAlias$ WITH(NOLOCK) WHERE 1=1  '
                       
  IF(@strWhere <> '')
	BEGIN 
		SET @strSql=@strSql+' AND '+@strWhere
	END

  SET @strSql=@strSql+' ORDER BY $TableAlias$.$orderByName$ DESC '
  EXEC SP_EXECUTESQL @strSql
   
  SET nocount OFF;
GO