SQL Server Insert into Command

Question

Sir I did a SQL Server Insert Command but i can't execute. Here the command. what the Problem this command has? Please correct the fault and send me. CREATE PROCEDURE ClassAdd @classId int @ClassName nvarchar(50) @Dates datetime AS insert into tbl_Class values(classId=@classIdclassName=@classNameDates=@Dates)

Pankaj Pandey · Answer

try it For Update CREATE PROCEDURE ClassUpdate @classId int @ClassName nvarchar(50) @Dates datetime as begin update tbl_Class set ClassName=@ClassNameDates=@Dates where ClassId=@classId end For Delete CREATE PROCEDURE ClassUpdate @classId int as begin delete from tbl_Class where ClassId=@classId end

Pankaj Pandey · Answer

hiii bineesh use this... CREATE PROCEDURE ClassAdd @classId int @ClassName nvarchar(50) @Dates datetime AS insert into tbl_Class (classIdclassNameDates) values(@classId@className@Dates) and don't forget to mark as answered when it helped.

Pankaj Pandey · Answer

Always Welcome from me dear..

Bineesh VP · Answer

Thank a lot Mr. Pankaj Pandey for Guiding me to the right answers

Bineesh VP · Answer

CREATE PROCEDURE ClassAdd @classId int @ClassName nvarchar(50) @Dates datetime AS insert into tbl_Class (classIdclassNameDates) values(@classId@className@Dates) Can you send me command same as this to Update Delete and and add a date to a particular row in a column?