First time using Enterprise

[timcadieux]

I just made a new table for the first time. How can i create an AutoIncrement Field and how do I make a text field 255, mine is at 16 and will nto let me change it?

 

[gmmastros]

Access's AutoIncrement field is the same thing as SQL Servers Identity field. Identity fields must be integers. You can specify the 'first number' to use and the 'amount to increment'

Text fields in SQL Server are the same thing as Access's Memo field. It takes 16 bytes to store the 'offset location' where the 'real' data is stored. Instead of using text fields, you really want to use VarChar fields. With a varchar, you can specify the maximum size. VarChar fields cannot be larger than 8000 characters.



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[gmmastros]

Here's a good article that you should read.

http://www.databasejournal.com/features/mssql/article.phpr/2212141

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[timcadieux]

thx folkz!