September, 2007

  • Vijay

    Logical flow of a query

    • 0 Comments
    The steps below is the logical flow of how a SQL statement is processed A) Cross Join the tables. If the query involves more than a table, the first two tables are cross-joined and the result set is then joined with the third table and so on and...
  • Vijay

    Datetime Imported from external system

    • 0 Comments
    SQL Server accuracy of milliseconds is 1/300 th of a second and the possible values are .000, .003 and .007. Any datetime value in SQL Server with milliseconds will be rounded to one the nearest of these three values. The table lists all possible last...
Page 1 of 1 (2 items)