Re: Multiuser record lock query?

From: Gitendra Proctor (gproctor_at_ihug.com.au)
Date: 03/30/04 

Date: Mon, 29 Mar 2004 16:01:11 -0800

Hi!
I am unfamilier with the term "Identity column", I looked up the documentation and as I understand it is much like the autonumber feature in MS ACCESS. I have used the autonumber (identity column) feature, when I wanted an unique sequentially incremented number for one table.

Here I have multiple tables, and I need a single unique sequential number (It's a docket number) each time a record is added to any of the tables.

Please let me know if this is the right interpretation of "Identity Column". Thankyou for taking the time to answer my query.

Regards
Gitendra

Relevant Pages

  • Re: Basic SQL
    ... John Gilson wrote: ... have multiple values for column b, but cannot figure it out - can someone help? ... Regards ... Given the original poster's stated input and required output, your query doesn't ...
    (comp.databases)
  • Re: Basic SQL
    ... John Gilson wrote: ... have multiple values for column b, but cannot figure it out - can someone help? ... The results of the query when running against the above data ... Regards ...
    (comp.databases)
  • multiple table results as one table in dataset
    ... I have a problem in returning data from multiple table as one table into ... as we know that in dataset we can populate it with multiple tables, ... i want the result of a following query which is coming from multiple ...
    (microsoft.public.vb.database.ado)
  • Re: SQL query help
    ... the multiple where criterion. ... I downloaded a query onto a table for a test ... numeric datatypes in Access do not have precision and scale the way ...
    (microsoft.public.access.queries)
  • RE: Loops
    ... table with multiple columns 5 for each pay period, ... I run my query for the pay period ending on 01/05/07 ... you are updating multiple tables. ...
    (microsoft.public.access.modulesdaovba)