1111

1111

شسیبشسیب

GO
/****** Object: StoredProcedure [dbo].[sp_GetNotAllowTitle] Script Date: 12/23/2018 2:37:01 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[sp_GetNotAllowTitle]
AS
BEGIN

SELECT N'تماس با ' + ValueStr As UrlTitle FROM Setting WHERE [Name] = N'WebSiteName'
UNION ALL
select Title from Category
UNION ALL
select Title from Page
UNION ALL
select PageTitle from Post


END




GO
/****** Object: StoredProcedure [dbo].[sp_GetNotAllowURL] Script Date: 12/23/2018 2:37:03 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[sp_GetNotAllowURL]
AS
BEGIN

SELECT REPLACE(N'تماس-با-' + ValueStr,' ','-') As UrlTitle FROM Setting WHERE [Name] = N'WebSiteName'
UNION ALL
select UrlTitle from Category
UNION ALL
select UrlTitle from Page
UNION ALL
select UrlTitle from Post


END

شسیبشس

گوشی
موبایل

سایر مطالب فرهنگ و هنر

تست دوم تست دوم

AS BEGIN SELECT N'تماس با ' + ValueStr As UrlTitle FROM Setting WHERE [Name] = N'WebSiteName' UNION ALL select Title from Category UNION ALL select Title from Page UNION ALL select PageTitle from Post END

شرکت آوا پروتئین

طراحی و سئو توسط تیم پورتال ایران مردم