QUESTIONS !! SQL server

[Guest_imported]

Hello !!
I am a beginer in MSQL =(
I have an application that use vb with access db, but it is too slow. =(
I am trying to find the best way to make it faster !! so I exported my access database to MSQL server !!
but I noticed that MSQL doesn't have Autonumber data types
=( Does SQL have some data type similar in SQL ?
and Do you think that with SQL I will see significant advantages?
thank you soo much !! and excuse me for my terrible English
Gabriela Leal

 

[foxdev]

SQL Server has an Identity column type. To use it, define the column as Integer data type and specify that it is Identity. The default start value is 1 with an increment of 1 for each record.

It is difficult to know if you will experience performance improvements, as it depends on the machines used, network speed, protocol, and so forth. By comparison to Access, though, I've got to believe it will be faster. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]