sqlserver2005 存储过程为什么总有错误
SETANSI_NULLSONGOSETQUOTED_IDENTIFIERONGOCREATEPROCEDUREselectUser@userIdvarchar(50),...
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE selectUser
@userId varchar(50),
@userCard varchar(50)
AS
BEGIN
SET NOCOUNT OFF;
SELECT * FROM User WHERE userId=@userId AND userCard=@userCard
END
GO
我放到查询里面执行
为何总说User附近有错误 展开
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE selectUser
@userId varchar(50),
@userCard varchar(50)
AS
BEGIN
SET NOCOUNT OFF;
SELECT * FROM User WHERE userId=@userId AND userCard=@userCard
END
GO
我放到查询里面执行
为何总说User附近有错误 展开
1个回答
展开全部
user是sqlserver里的关键字
SELECT * FROM User WHERE userId=@userId AND userCard=@userCard
这句改成
SELECT * FROM [User] WHERE userId=@userId AND userCard=@userCard
也就是user上加一对中括号试试
SELECT * FROM User WHERE userId=@userId AND userCard=@userCard
这句改成
SELECT * FROM [User] WHERE userId=@userId AND userCard=@userCard
也就是user上加一对中括号试试
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
