Hello fiends i am creating on stored procedure but i am not able to pass list as paramter code is as following
USE [DBdiamond]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE OR ALTER PROCEDURE [dbo].[ListDiamonds]
(
@shape Nvarchar(Max)=null
) AS
BEGIN
if @shape='' or @shape='NULL'
BEGIN
select * from Diamondmst;
END;
ELSE
BEGIN
select * from Diamondmst d where d.shape IN (@shape);
END;
END;
i want to pass the @shape like @share='ROUND','PEAR'
so how can i pass sting list pls suggest