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
|
