customsql.txt

Job post Job post

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER PROCEDURE [dbo].[JobPostGetAll]
	
AS

SELECT
	[JobId],
	[Code],
	[ShortDescription],
	[Description],
	[Status],
	[SortNumber],
	[DateCreated],
	[JobDate],
	[Title]
FROM JobPost
ORDER BY [SortNumber]