Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Why does the new 'TOP' command in SQL 7 not work? I get a syntax error. Also ALTER TABLE and other SQL 7 only commands.
Neil Pike
January 24, 2000
1 Min Read
A. Usual reason for this is that the command only works on SQL 7 mode databases. If you have migrated an existing 6.5 database then it is probably still set to 6.5 compatibility mode. Use sp_dbcmptlevel to check and set it to SQL 7 mode.
About the Author
You May Also Like
.jpg?width=700&auto=webp&quality=80&disable=upscale)
