ajf Posted April 15, 2015 Share Posted April 15, 2015 i'm defining a parameter @para1 I want to be able to know that if @para1 brings back a null value, is there a case to then say... """ if @para1 is null then declare @para1=@para2 """" Tried a few combos and cant seem to find the result i'm after... does anybody know how this can be done? any help would be appreciated Thanks Link to comment Share on other sites More sharing options...
justsomeguy Posted April 15, 2015 Share Posted April 15, 2015 I don't think you would use declare in that context, that would be for creating a new variable. You're just trying to set a value, not declare a variable. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now