关于存储过程的问题

[peakjian]

CREATE PROC UpGetCustomers
@CustomerID int,
@CustomerName nvarchar(20) = '%'
AS
SELECT CustomerID, CustomerName,
FROM Customers
WHERE CustomerID = @CustomerID AND CustomerName LIKE @CustomerName
在这样的存储过程中，对于字符型的参数将其default value设置为'%'，就可以在不需要这个条件的时候将其忽略掉。但是如果是int, float等数字型的该如何在不需要情况下，将他们忽略。

[愉快的登山者]

CREATE PROC UpGetCustomers
@CustomerID int,
@CustomerName nvarchar(20) = '%'
AS
SELECT CustomerID, CustomerName,
FROM Customers
WHERE CustomerID = @CustomerID AND cast(CustomerName as varchar) LIKE @CustomerName

[ReplyRobot]

UP

[pengdali]

CREATE PROC UpGetCustomers
@CustomerID int,
@CustomerName nvarchar(20) = '%'
AS
SELECT CustomerID, CustomerName,
FROM Customers
WHERE CustomerID = isnull(@CustomerID,customerid) AND CustomerName LIKE @CustomerName