• Access Filtering


    Mwpv145 pointsBadges:

    How do I interpret the EXPLAIN plan of a particular SQL which has "Bytes" and "Cost(CPU%)" columns?

    ITKE352,565 pointsBadges:
  • Finding which columns contain data in a table

    I have to establish which columns in a table have data present. Each row has up to 100 columns, and not all of the columns contain data relating to the row. So in Table 1, Col1 Col2 Col3 Col4 Row 1 abc Row 2 abc Row 3 abc Would give a report showing that Table 1 has Columns Col1, Col2, Col4 being...

    TedGiles5 pointsBadges:
  • Obtaining the value of certain columns in a SQL database

    I have created the following trigger that inserts data into a SQL table when a specific column is updated. I would also like to obtain the current value of certain columns of the updated row. To do this, I've been using the INSERT command, but I keep receiving NULL values in return. This is the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Access Database, columns, calculatons

    Hello to everyone. I really need an answer to this question. anyone that can help, it is extremely appreciated. I have a database that has a number column, which relates to a text colum. the text colum has two differnt types of information in it. i need to add the number column, but only for...

    Mstweety10 pointsBadges:

Forgot Password


Your password has been sent to:

To follow this tag...


REGISTER or login:

Forgot Password?
