我用asp.net写三层架构,sql语句是这样的,SELECT * FROM WKM_Admin WHERE UserName = @UserName ,但老是报错,说是对象名 'WKM_Admin' 无效。 可在sql server2005新建查询的时候都能通过,这是怎么回事啊?可如果我用SELECT * FROM UserInfo WHERE UserName = @UserName 就行,只是改了个表名,是不是表名有问题啊,可为什么在sqlserver中就能执行查询呢
调试欢乐多
try
SELECT * FROM [WKM_Admin] WHERE UserName = @UserName
go
SELECT * FROM [WKM_Admin] WHERE UserName = @UserName