تست دوم

تست دوم

عنوان اول جهت بالای سایت

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

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

1111 1111

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

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

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