> I need to know like in MS Access we have an autonumber data type which can be
> made the primary key. Is there a data type in SQL database also which can be
> made the primary key & which is automatically filled by the database? Is
> uniqueIdentifier a good choice & is it filled by the database itself?
>
> I need this coz my table doesnt have a primary key & i need a primary key
> for it.
> --
> pmud
Re: Q: Datatables, Datasets and updating ... I have two tables A and B in the SQL database.... ID_A (the primary key of A) and NAME_A (a string... (microsoft.public.dotnet.languages.csharp)
Re: problem using identity column as primary key ... >> I am thinking of creating an identity column to use it as primary key... More and more programmers who have absolutely no database training are ... the gap in the sequence is not filled in and the sequence ... vin CHARNOT NULL REFERENCES Motorpool); ... (microsoft.public.sqlserver.programming)
Re: Q: Datatables, Datasets and updating ... the automatic updating features of a DataSet and DataAdapter. ... > transfer the data inputted into the SQL database.... >> The problem seems to be that you have defined Primary Key to mean Identity ... (microsoft.public.dotnet.languages.csharp)
Re: Updating the SQL key value ... before creating the database, by the time I've come to pick a primary key,...articles, each of which must be issued under a particular licence (e.g. ...GPL GNU General Public Licence http://www.gnu ... ... (comp.lang.php)
Re: Concatenate and Null Values -- Features ... Tony Toews dislikes cascade deletes as well as cascade updates,... fence regarding the use of natural versus surrogate (autonumber) keys. ...Database Normalization Tips ... For optimal database design and performance, the primary key of a table ... (microsoft.public.access.reports)
