Link to home
Start Free TrialLog in
Avatar of aakshi jain
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.
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Hi,
Please try this -

DECLARE @OrderId AS BIGINT 
SET @OrderId = 10028

SELECT * FROM Orders
WHERE CAST(OrderId AS BIGINT) = @OrderId

Open in new window


Hope it helps!
Avatar of Máté Farkas
What is the error message?
I see only 2 issues can be there.

Are you using SQL 2005.
Or  datatype of OrderId
Avatar of aakshi jain
aakshi jain

ASKER

Yes I am using sql 2005.
ASKER CERTIFIED SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks