Untitled

USE [scoot]
GO
/****** Object:  StoredProcedure [dbo].[selectOrsearch_material]    Script Date: 14/12/2021 20:05:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[selectOrsearch_material]
	@searchtxt nvarchar (50)
AS
BEGIN
	SELECT [id]
      ,[name] as [اسم العتاد]
      ,[number] as [الكمية]
      ,[prix_achat] as [سعر الشراء للوحدة]
      ,[loses] as [الخسائر]
      ,[motifs] as [ملاحظات]
  FROM [dbo].[material] WHERE @searchtxt = '' or [name] LIKE N'%'+ @searchtxt + '%'
END