尝试以下...

try the following...

CREATE PROCEDURE GetMyData @Day int
AS
SELECT @Day FROM DoctorsAvailability 
GO

您需要在星期一5到星期四等通过4....

我不确定这种逻辑，我无法测试它，因为我这里没有sql server ...


问候
塞巴斯蒂安

You need to pass 4 for Monday 5 for tuesday etc....

I am not sure of this logic, and i am unable to test it as i don''t have sql server here...


Regards
Sebastian

尝试一下

try this

CREATE PROCEDURE GetMyData @Day int
AS

DECLARE @SQL NVARCHAR(MAX)

SET @SQL=' 
SELECT '+@Day+' FROM DoctorsAvailability
'

EXEC(@SQL)

GO