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 |
|
abc
Starting Member
48 Posts |
 Posted - 2001-12-12 : 05:33:26
|
| I'm learning Select query by reading book online. But I don't uderstand the description for [OPTION] and [BROWSE] optional in SQL syntax. Could any one tell me more detail about them, give me an example for illustrateThanks for your attention |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2001-12-20 : 16:09:03
|
| Browse:is a dblib for C option that allows you to keep a resultset open, and modify the data while browsing it. Think of it as similar to how Access works with it's forms.Option:is for giving the query optimizer hints (Actually directives) and having that hint persist throuought the entire Query.Books online explains each of these very well, and gives examples.-Chad |
 |
|
|
|
|
|
Browse and Optional