Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Amn
Starting Member
1 Post |
 Posted - 2004-07-13 : 10:39:25
|
| Hi all!I am trying to figure out how much of ANSI SQL standard Access does support, and where to find documents stating WHAT it does support.It is very difficult for me to follow the tutorials, because obviously almost none of them work for Access, and I already found out the hard way that it does not support stored procedures and cursors...Any good links on specs or help ? Access' own help does not suit for developers, i guess, it is just plain help for newbies..I am particularly interested on how I can fetch a limited number of records out of SELECT, ORDER BY query (record paging), without fetching all the records and thus wasting memory of my script. |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-07-13 : 18:35:12
|
| There is a part in the Access help file called 'Microsoft JET SQL Reference', or something similar. This tells you what Access SQL supports. If you can't find it in the help file, check on microsoft's technet/msdn site.With regard to fetching limited records, Access does support the TOP clause. But if you're interested in reading paged recordsets, check out the ADO documentation. What exactly are you trying to do? |
 |
|
|
|
|
|
What parts of SQL does Access support ?