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 ProductSearchCount_Select
|
|
create proc ProductSearchCount_Select
|
|
|
|
@ProdName nvarchar(50)
|
|
|
|
as
|
|
|
|
select count(*) from dbo.Product where ProdIsDeleted=1 and ProdName like @ProdName
|