select count(id) from user错在哪里?
为什么用select count(id) from [user]就可以但其它的表
我都没有加那个中括号的可以用

I love you not because of who you are, but because of who I am when I am with you!
本示例声明一个 char 类型的变量,将 USER 的当前值赋给它,然后打印该变量以及文本说明。
DECLARE @usr char(30)
SET @usr = user
SELECT 'The current user's database username is: '+ @usr
GO
下面是结果集:
-----------------------------------------------------------------------
The current user's database username is: dbo