Incorrect syntax near SqlParameter

Question

I have this code

Dim q = New SqlCommand("SELECT * FROM [ddddd] WHERE ([Day] >= %XX ) AND ([Day] <= %YY )")
q.Parameters.Add(New SqlParameter("XX", rangeFrom.Value))
q.Parameters.Add(New SqlParameter("YY", rangeTo.Value))

q.Connection = dbc

Dim rd = q.ExecuteReader()
' ...

It throws a SqlException on the

Dim rd = q.ExecuteReader()

line with message

Incorrect syntax near 'XX'

Why?

what are the % signs for?

Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp

2016-03-26 19:09:10 +00:00
Commented Mar 26, 2016 at 19:09 — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Mar 26, 2016 at 19:09

marc_s · Accepted Answer · 2016-03-26 19:11:02Z

4

SQL Server parameters need to be prefixed with a @ (not a % as you've used it):

SELECT * 
FROM [ddddd] 
WHERE [Day] >= @XX AND [Day] <= @YY

and then also use the leading @ when declaring the parameters:

q.Parameters.Add(New SqlParameter("@XX", rangeFrom.Value))
q.Parameters.Add(New SqlParameter("@YY", rangeTo.Value))

answered Mar 26, 2016 at 19:11

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Incorrect syntax near SqlParameter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related