Since someone mentioned only the support in passing, not the details, I thought I'd throw out this:
Microsoft SQL Server using the following syntax for hints: SELECT * FROM FOO WITH (hints) 'hints' can included locking hints, index-usage hints, and whatnot. I will quote some of the proposed examples and give the equivalent in MSSQL. The reason is, language extensions are a *bitch*, because you have to do massive regression testing on the parser to ensure backwards and forwards compatibility. This way, we can use whichever syntax is easier to support programmatically. (Remember: We're smarter and more flexible than the computers. If writing our queries one way is far more efficient for the computer to process, we should do that.) > >> SELECT * FROM tablex INDEX BY indexy WHERE ... ORDER BY ...; > select * from tablex with(index(indexy)) where... order by... > > >> SELECT * FROM tablex INDEX BY ROWID WHERE ... ORDER BY ...; > > >> SELECT * FROM tablex NOT INDEXED WHERE ... ORDER BY ...; > These two, as far as I understand, would be expressed to SQL Server identically: "with (index(0))". -- -- Stevie-O Real programmers use COPY CON PROGRAM.EXE _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
