You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
|
|
|
drop proc ProductSearchPrompt_Select
|
|
create proc ProductSearchPrompt_Select
|
|
|
|
@ProdName nvarchar(50)
|
|
|
|
as
|
|
|
|
select distinct ProdName from dbo.Product where ProdName like @ProdName and ProdIsDeleted=1
|
|
|
|
ProductSearchPrompt_Select '2%'
|