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]
2 回答
慕婉清6462132
TA貢獻1804條經驗 獲得超2個贊
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]
慕慕森
TA貢獻1856條經驗 獲得超17個贊
參數類型錯誤，將 public bool Update(string id 換成 public bool Update(int id 即可。當然，函數調用也要變更，這是個int類型而不是字符串類型。
- 2 回答
- 0 關注
- 249 瀏覽
添加回答
舉報
0/150
提交
取消