Hi all,i hav a textbox control which is a search field and lets say ex:abc123456787 i will pass value
FCI based on partial search i want to display records in grid and also if i pass values like
ex:absc4696489,piok8756592 i need to fetch data from database how to acheive this either in db2/sql server.Thanks
Amit Kumar SinghPosted Feb 15, 2016, 6:25 AM
ALTER PROCEDURE [dbo].[Employee_proc]
(
@Id INT,
@NAME VARCHAR(50),
@GENDER VARCHAR(50),
@SALARY VARCHAR(50),
@COUNTRY VARCHAR(50),
@Opt varchar(5)
)
AS
BEGIN
BEGIN TRY
IF(@Opt='S')
BEGIN
SELECT NAME FROM Employee WHERE NAME like @NAME + '%'
END
IF(@Opt='S1')
BEGIN
SELECT * FROM Employee
END
END TRY
BEGIN CATCH
DECLARE @ErrorMSG NVARCHAR(4000), @ErrorSeverity VARCHAR(10), @ErrorState VARCHAR(10), @ErrorProcedure NVARCHAR(200)
SET @ErrorMSG = ERROR_MESSAGE()
SET @ErrorSeverity = ERROR_SEVERITY()
SET @ErrorState = ERROR_STATE()
SET @ErrorProcedure = ERROR_PROCEDURE()
RAISERROR(@ErrorMSG, @ErrorSeverity, @ErrorState, @ErrorProcedure)
END CATCH
END
Shubham KumarPosted Feb 15, 2016, 6:05 AM