locked
Select Statement RRS feed

  • Question

  • User-797751191 posted

    Hi

      Is the below Statement correct

    using (SqlCommand cmd = new SqlCommand("SELECT Count(*) FROM [Test] Where [Invoice No]=@InvoiceNo and [Location] = @Store and [Status] in ('','Pending')", con))

    Thanks

    Monday, June 24, 2019 3:25 PM

Answers

  • User753101303 posted

    Hi,

    Yes it is syntactically correct. If you have a problem when running this statement it would be easier to directly discuss the problem you have (which error message and on which line).

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, June 24, 2019 3:32 PM

All replies