CREATE PROC [dbo].[mySPROC]
@ID as INT = null
AS
BEGIN
SELECT *
FROM MyTable
WHERE ID = @ID
END
CREATE PROC [dbo].[mySPROC]
@ID as INT = null,
@dtStart as DATETIME = null,
@dtEnd as DATETIME = null
AS
BEGIN
SELECT *
FROM MyTable
WHERE (ID = @ID OR @ID is NULL)
AND ((MyDate >= @dtStart And MyDate <= @dtEnd)
OR (@dtStart IS NULL And @DtEnd IS NULL))
END
@ID as INT = null
AS
BEGIN
IF @ID is not null
SELECT *
FROM MyTable
WHERE ID = @ID
ELSE
SELECT *
FROM MyTable
END