What is the correct Syntax to be applied for "@[System::ErrorDescription]" inside the query like "INSERT" ? I am unable to retrieve the correct Error Description inside the table, as the result in the table is showing as "@[System::ErrorDescription]". I am not getting the result !
+1
A:
Use a command like:
INSERT YourTable (errordesc) SELECT ?
And then put a parameter called 1 in, populated with @[System::ErrorDescription]
Rob Farley
2010-03-15 12:44:07
using SELECT ??? ok, will try out !!!!! havent thought about that !!!
Sreejesh Kumar
2010-03-15 19:18:09
and i didnt understand !!!! parameter 1 ??? where ???
Sreejesh Kumar
2010-03-15 19:18:45
what is the correct format which includes the parameter 1 which you mentioned about ??
Sreejesh Kumar
2010-03-15 19:19:19
Have a look at http://technet.microsoft.com/en-us/library/ms140355.aspx for more info on how to use parameters, because it depends slightly on what type of connection you have. But basically, go to the Parameter Mapping tab, and put it in there.
Rob Farley
2010-03-16 00:37:54
Ok. I have accepted this answer
Sreejesh Kumar
2010-04-12 12:17:12