create procedure spuserdetails (@Name varchar(50), @DOB datetime, @Addr varchar(70), @phn int, @Country varchar(50), @States Varchar(50), @City varchar(50) ) As Begin insert into userdetails values(Name=@Name DOB=@DOB, Addr=@Addr, phn=@phn, Country=@Country, States=@States, City=@City) end
Msg 128, Level 15, State 1, Procedure spuserdetails, Line 13 The name "Name" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.
insert into TABLENAME (FIELD1, FIELD2, ... , FIELDN) values (VALUE1, VALUE2, ... , VALUEN)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)