Re: autonumber data type

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dinesh T.K (tkdinesh_at_nospam.mail.tkdinesh.com)
Date: 05/24/04 

Date: Mon, 24 May 2004 13:22:38 +0530

Daniel,

Correct.If you have installed BOL during the SQLServer setup, you can find
it in start menu | SQLServer folder.If not, please refer:
'Books Online for SQL Server SP3'
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp 

--
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Daniel" <dwbnews@hotmail.com> wrote in message
news:#EEEH6VQEHA.2132@TK2MSFTNGP11.phx.gbl...
> What?  Is BooksOnLine some documentation that came with SQL Server 2000?
>
>
> "Dinesh T.K" <tkdinesh@nospam.mail.tkdinesh.com> wrote in message
> news:%2329XZ2VQEHA.3232@TK2MSFTNGP11.phx.gbl...
> > Daniel,
> >
> > Refer IDENTITY columns in BooksOnLine.An example:
> > CREATE TABLE students
> >  (stud_id int IDENTITY(1,1),
> >   stud_name varchar(100)
> > )
> >
> > --
> > Dinesh
> > SQL Server MVP
> > --
> > --
> > SQL Server FAQ at
> > http://www.tkdinesh.com
> >
> > "Daniel" <dwbnews@hotmail.com> wrote in message
> > news:OdOkKzVQEHA.3012@TK2MSFTNGP09.phx.gbl...
> > > Is there an equivalent in SQL Server to the autonumber data type in
> > Access?
> > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Cascade update to two fields in a table...
    ... Both of these refer to UserName in tblUsers. ... you cannot set up cascading foreing keys, ... The SQL Server developers ...
    (comp.databases.ms-sqlserver)
  • Re: I cant seem to access my fulltext data
    ... log from messages coming from MSSearch or MSSCi? ... This might refer to your ... The most common reason for such a failure is the the SQL Server Service ...
    (microsoft.public.sqlserver.fulltext)
  • RE: Cannot generate SSPI context
    ... Let us refer to the following steps to troubleshoot the issue: ... How to troubleshoot the "Cannot generate SSPI context" error message ... How to use Kerberos authentication in SQL Server ... from your newsreader: microsoft.private.directaccess.partnerfeedback. ...
    (microsoft.public.windows.server.sbs)
  • RE: Newbie replication questions
    ... Microsoft MSDN site since I believe that no books can describe more ... For SQL Server Replication Management and Configuration, please refer to: ...
    (microsoft.public.sqlserver.replication)
  • Can I refer to a local recordset after the FROM clause ?
    ... In order to improve performance for a SQL Server DB which resides on an ... FROM clause to a local recordset instead of a table. ... to be accessed more than 1000 times within a loop. ... I want to perform perform in-line SQL statements which refer to ...
    (microsoft.public.vb.database.ado)