Monday, November 6, 2023

How to get select- 0 in dropdown list from database select query as first row - 0th index sql server

 ALTER PROCEDURE [dbo].[RPT_GetCrimeCategory]  

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

select LKSCOMPLAINTSOURCE.LookupID, LKSCOMPLAINTSOURCE.Description from dbo.Lookup LKSCOMPLAINTSOURCE WITH(NOLOCK)where  LKSCOMPLAINTSOURCE.LookupCategory = 126

union 

select 0, 'Select'

END

No comments:

Post a Comment