• Login

Snippets

12

 

PROCEDURE GIBS_SEO_Content nvarchar(50) = null

 

AS

BEGIN

if

(len(@city)=0)

begin

set

@city=null

end

 

SET NOCOUNT ON;

 

 

 

SELECT City, Village , REPLACE (City,' ','-') + '/' + REPLACE (Village,' ','-') AS EncodeVillageFROM Town_to_VillageWHERE (Village = coalesce(@City,'Harwich') )

END

GO

SET

ANSI_NULLS OFF

GO

SET

QUOTED_IDENTIFIER OFF

GO

 

 

@City

CREATE

Post Rating

Comments

There are currently no comments, be the first to post one!

Post Comment

Name (required)

Email (required)

Website