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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-18 : 09:38:30
|
| Balaji writes "I did a simple query to get the TOP n values in my Database,"SELECT TOP 10 * FROM Company"Which Raises the following errorServer: Msg 170, Level 15, State 1, Line 1Line 1: Incorrect syntax near '10'.While Running a similar query in PUBS does not.Is there some DATABASE Setting which influence this?VERSION INFO:Microsoft SQL Server 7.00 - 7.00.623 (Intel X86) Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 5)RegdsBalaji.v" |
|
|
|
|
|
Using TOP Errors