This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 82%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Could two queries share the same parameter/variable?
Probably.
(And if you want a more detailed answer, you need to ask a more detailed question.)
I want to be able to return row 2 and 4 in this situation
I would like to get the same results without needing the where clause rewritten every time.
So in your second screenshot, you are reusing the variable. What is your problem?
Hi @Jonathan Brotto
When two queries are in same batch, then it is possible.
Check this simple sample:
Declare @ID INT=10001
select * from DemoTable where ID = @ID;
select * from DemoTable where ID <> @ID;
When the two queries are not in one batch like this:
Declare @ID INT=10001
select * from DemoTable where ID = @ID;
GO
select * from DemoTable where ID <> @ID;
You might need to declare the parameter again.
Best regards,
Cosmog
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
I don't get the same results . What is wrong with my code?
It is because you did not specific the length of Varchar. The default value of length is 1 for varchar datatype when used in variable declaration.
See:
DECLARE @POnumber AS VARCHAR = 'abc';
SELECT @POnumber,DATALENGTH(@POnumber)
Ah, good catch, Cosmog!
When I don't specify an arbitary length for varchar. I get the incorrect results but in my case putting 50 I get the correct results. Is there a way not needing to enter a value?
DECLARE @POnumber AS VARCHAR(50) = '6801367194';
SELECT @POnumber, DATALENGTH(@POnumber)
SELECT * FROM SA15 WHERE PONo = @POnumber
SELECT * FROM SA15B WHERE PONo = @POnumber
Is there a way not needing to enter a value?
No. varchar alone always means varchar(1).
Is there a way not needing to enter a value?
No. If the POnumber is like 6801367194', then you need to specify the length like varchar(n) or varchar(max). The single varchar equals to varchar(1).