CREATE PROCEDURE epd_item_master_search_sp( @item_codes char(25))
AS
SELECT @item_codes= RTRIM(@item_codes) + '%'
select item_code,item_name,item_model,item_spec from epd_item_master where item_code like ''''+@item_codes +'%'
order by item_code ASC;
exec epd_item_master_search_sp 'GB';
AS
SELECT @item_codes= RTRIM(@item_codes) + '%'
select item_code,item_name,item_model,item_spec from epd_item_master where item_code like ''''+@item_codes +'%'
order by item_code ASC;
exec epd_item_master_search_sp 'GB';
AS
SELECT @item_codes= RTRIM(@item_codes) + '%'
exec('select item_code,item_name,item_model,item_spec from epd_item_master where item_code like '''+@item_codes+'''')
order by item_code ASC;
CREATE PROCEDURE epd_item_master_search_sp( @item_codes varchar(25))
AS
SELECT @item_codes= RTRIM(@item_codes) + '%'
select item_code,item_name,item_model,item_spec
from epd_item_master where item_code like @item_codes
order by item_code ASC;
AS
SELECT @item_codes= RTRIM(@item_codes) + '%'
exec('select item_code,item_name,item_model,item_spec from epd_item_master where item_code like '''+@item_codes+''' order by item_code ASC')