此SQL查询有什么问题?
更新学生设置ID ='3',电子邮件='[email protected]',密码='20105',名称='3',FatherName ='3',CNIC = 3,ContactNo = 3
,Section ='G' ,部门=“ EE”,图像=“ 10414450_624151571051295_2997621265926572989_n.png”,SemesterId = 1,其中Id =“ 3”
如果学生表是:
CREATE TABLE [dbo].[Student] (
[Id] VARCHAR (10) NOT NULL,
[Email] VARCHAR (50) NOT NULL,
[Password] VARCHAR (50) NOT NULL,
[Name] VARCHAR (50) NOT NULL,
[FatherName] VARCHAR (50) NULL,
[CNIC] CHAR (13) NOT NULL,
[ContactNo] CHAR (11) NOT NULL,
[Department] VARCHAR (10) NULL,
[Degree] VARCHAR (10) NULL,
[Image] VARCHAR (MAX) NULL,
[SemesterId] SMALLINT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC),
FOREIGN KEY ([Department]) REFERENCES [dbo].[Department] ([Id]),
CONSTRAINT [FK_Student_ToDegree] FOREIGN KEY ([Degree]) REFERENCES [dbo].[Degree] ([Name])
);
在此先感谢帅哥!
Section
您的表中没有列。我认为应该是Degree
。
所以您的查询将是
UPDATE Student SET Id = '3', Email = '[email protected]', Password = '20105', Name = '3', FatherName = '3', CNIC = 3, ContactNo = 3, Department = 'EE', Degree = 'G', Image = '10414450_624151571051295_2997621265926572989_n.png', SemesterId = 1 WHERE Id = '3'
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句