How can I pass multiple values from same column in a query?
How can I pass multiple values from same column in a query? I am using vb.net and sql server 开发者_开发问答database.
With my query an exception is generated saying that @booking_date has already been declared try a different variable....
My query is:
Dim da As New SqlDataAdapter("select * from Bookings where booking_date Between (@booking_date AND @booking_date) AND booking_time Between (@booking_time AND @bookinbg_time) AND game = " & x, con)
Do you need the parentheses around the variables?
精彩评论