aakshi jain
asked on
SQL Error - Query
Hello there,;
What is the error in this code.?
DECLARE @OrderId AS INT = 10028
SELECT * FROM Orders
WHERE OrderId = @OrderId
Appreciate your help.
What is the error in this code.?
DECLARE @OrderId AS INT = 10028
SELECT * FROM Orders
WHERE OrderId = @OrderId
Appreciate your help.
What is the error message?
I see only 2 issues can be there.
Are you using SQL 2005.
Or datatype of OrderId
Are you using SQL 2005.
Or datatype of OrderId
ASKER
Yes I am using sql 2005.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
Please try this -
Open in new window
Hope it helps!