What are the differences between Access and SQL Server?
AutoNumbers are Int fields with an Index Indexes can be applied at any time, not just on a new table InStr and Mid become CharIndex and SubStr You can’t refer to a date within # anymore, SQL Server uses ‘ Lists for IN() can’t end in a , anymore Data isn’t written immediately, it’s queued SQL Server can return the Index field within the SQL You can set-up Stored Procedures to do complex SQL commands and just call them within SQL You can by-pass the record locking to improve speed You can alter a table definition while it’s still in use to question
Related Questions
- How should I handle mismatched SQL Server logins? Can you explain the differences between Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)?
- What are the similarities and differences between Microsoft Access and Microsoft SQL Server?
- What are the main differences between Access and SQL Server?
