try..
insert into VersionLog_Details( Ref_UserID, Server_Name, Database_Name, Object_Type, Object_Name, Comment, Changes_Date,Object_Code) values(
@Ref_UserID,
@Server_Name,
@Database_Name,
@Object_Type,
@Object_Name,
@Comment,
@Changes_Date,
@Object_Code
)
command.Parameters.AddWithValue("@Ref_UserID", '4');
command.Parameters.AddWithValue("@Server_Name", 'VOI_05\SQLEXPRESS');
.
.
.
.
string strCmnts="Hii How are You";
command.Parameters.AddWithValue("@Comment", strCmnts);
command.Parameters.AddWithValue("@Changes_Date", '1/30/2015 2:12:31 PM');
srtring strSp=@"CREATE procedure ra
(
@EmpID int
)
as
begin
Insert Into MyEmployees values('s','s','','','','')
end
select * from MyEmployees')";
command.Parameters.AddWithValue("@Object_Code", strSp);
ref.
https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.parameters(v=vs.110).aspx[
^]