将 nvarchar 值 'Category' 转换为数据类型为 int 的列时发生语法错误，咋办？

Question

IF NOT EXISTS (SELECT * FROM sysobjects WHERE Name = OBJECT_ID(N'[dbo].[Role]') AND type in (N'U'))BEGINCREATE TABLE [dbo].[Role]([ID] [int] IDENTITY(1,1) NOT NULL,[RoleName] int NULL,CONSTRAINT [PK_Role] PRIMARY KEY CLUSTERED ([ID] ASC)) ON [PRIMARY] 

Answer 1

IF NOT EXISTS (SELECT * FROM sysobjects WHERE Name = 'Role' AND type = 'U')
BEGIN
CREATE TABLE [dbo].[Role](
[ID] [int] IDENTITY(1,1) NOT NULL,
[RoleName] int NULL,
CONSTRAINT [PK_Role] PRIMARY KEY CLUSTERED 
(
[ID] ASC
)
) ON [PRIMARY]

Answer 2

参数类型错误，将 public bool Update(string id 换成 public bool Update(int id 即可。当然，函数调用也要变更，这是个int类型而不是字符串类型。