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-03-21 : 18:22:22
|
Barry writes "I'm TRYING to use a 'SELECT TOP' statement in my stored procedure, and I keep getting a syntax error with the number I supply... for example, using:
SELECT TOP 1 FROM USERPROFILE WHERE NETID LIKE 'B%' ORDER BY NETID
...
gives the following error:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '1'.
...
what gives? I'm using MS SQL SERVER 7.0 SP2 on a WIN 2000 Professional machine....I've tried this in several different ways on several different tables....the data is there, the column is there....I've written several hundred stored procedures and recently upgraded from 6.5 to 7.0 and I'm trying to use the new features.
Thanks for any ideas,
Barry" |
|
|
|
|
|
Syntax error in simple 'SELECT TOP' statement