In a SQL Server database, I have a table Priority with 3 columns id, name and registered date. For registered date, default value is getdate()which automatically generates the record created date and time. Now in
grid view, I want to search records using this registered date.In grid
view, I have dropdown search by using name and date.
- CREATE PROCEDURE [dbo].[SEARCHPRIOR]
- @SearchBy VARCHAR(50),
- @SearchVal VARCHAR(50),
- AS
- BEGIN
- IF @SearchBy = '1'
- BEGIN
- SELECT * FROM PRIORITY WHERE P_NAME LIKE '%' + @SearchVal + '%'
- END
- ELSE IF @SearchBy = '2'
- BEGIN
- SELECT * FROM PRIORITY WHERE P_TS LIKE '%' + @SearchVal + '%'
- END
- ELSE
- BEGIN
- SELECT * FROM PRIORITY
- END
- END
I have tried searching with this query but getting no results found in grid view. This is how table look like in SQL Server:
P_ID P_NAME P_TS
-------------------------------------------
1 High 2019-04-23 16:17:08.097
2 Medium 2019-04-24 16:17:23.070
3 Low 2019-04-25 16:17:32.420