selecting from ''user''
-
Hi all: I have a table named 'user' in my database. Unfortunately im not able to select from the table even if I qualify the table with user name 'dbo.user'. Any ideas on what could be the problem??
-
user is a reserved word, so you need to quote it.
SELECT * FROM [dbo].dbo would not have needed to be quoted, but it is never wrong to do it.
-
Thanks Chris. Its working
-
Or you can always rename the table to users and avoid the problem altogether.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply