Access counter type equivalent in SQL-Server 6.0

Article View: comp.databases.ms-sqlserver

Article #61

Back to comp.databases.ms-sqlserver Previous Next

#61

From: John A. Simpson
Date: Mon, 01 Apr 1996 00:00

13 lines
1136 bytes

I need to find out if there is some sort of equivalent to the Counter type in 
Access for SQL Server 6.0.  I already know about IDENTITY and TRIGGERs, 
however, both of these methods increment the counter field after the data is 
committed.  Our project is using the counter field as a foreign key so I need 
this field to be incremented before I commit the data.

Can anyone help me???

Thanks...

John A. Simpson
Analysts International Corp.
jsimpson@i1.net

Technical Details

Message-ID: <4jp2qv$puj@news1.i1.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11355a,c59097bc5364613e,start
X-Google-Attributes: gid11355a,public
X-Google-Thread: 104de1,c59097bc5364613e,start
X-Google-Attributes: gid104de1,public
X-Google-Thread: 11acf5,c59097bc5364613e,start
X-Google-Attributes: gid11acf5,public
From: jsimpson@i1.net (John A. Simpson)
Subject: Access counter type equivalent in SQL-Server 6.0
Date: 1996/04/01
Message-ID: <4jp2qv$puj@news1.i1.net>
X-Deja-AN: 145262364
content-type: Text/Plain; charset=US-ASCII
organization: Internet 1st, Inc.
mime-version: 1.0
newsgroups: comp.databases.ms-sqlserver,bit.databases.mssql-1,bit.listserv.sqlinfo