Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sunil Chandurkar Writing Dynamic Stored Procedure RE: Writing Dynamic Stored Procedure

  • June 3, 2009 at 10:15 am

    #1004157

    sunil,

    You can use this style too....

    set @Gender = isNull('M', '_')

    set @Age = isNull(22, 0)

    SELECT * FROM test_EmployeeDetails

    Where Gender LIKE @Gender AND Age > @Age

    Thanks!

    Azeem