Friday, March 16, 2012

optional variable in SQL

Hi I want to know is there any optional variable in sQL LIKE this

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