CREATE PROCEDURE LOG_Login
@dotnet.itags.org.email nvarchar(250),
@dotnet.itags.org.id uniqueidentifier, ' I want to make this optional
@dotnet.itags.org.ip varchar(50)
AS
INSERT INTO log
()
VALUES )
GOaspguys,
You can make the parameter optional by specifying a default value. For instance:
@.optionalParm as varchar(50) = "default value on optional parm"
cjmaxey
thanks it works
0 comments:
Post a Comment