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.
ArtsAndCrafts/DataSql/ProductSearchCount_Select.sql

10 lines
187 B

drop proc ProductSearchCount_Select
create proc ProductSearchCount_Select
@ProdName nvarchar(50)
as
select count(*) from dbo.Product where ProdIsDeleted=1 and ProdName like @ProdName