sql query

  1. S

    Hi guys just have a question regarding parameterized queries.

    Initially I was concatenating my SQL queries, i was then informed that it would be best to use parameterized queries to prevent SQL Injection. I've now done that and everything works fine, however when posting on a forum yesterday about one of my queries not working properly, a person told me...
  2. P

    How do I optimise the query

    Hello folks, I have prepared one query, but I feel this can be even more optimised! But I'm not sure what can be done Query SELECT TOP 10 * FROM ( SELECT co.orderid, co.orderStatusId, co.paymenttransactionstatusid, ( SELECT...
  3. S

    SQL to build point arrays

    Hi I have a link and a node SQL Server table as below. I need to build a number of lines using the node and link tables. Non-vertex nodes denote end points of the line. In C# I possibly need build a dictionary of coordinates for each line. Any suggestions what would be the best way to...
Top Bottom