Error: Error converting data type int to nvarchar
This error occurs when a stored procedure which returns a value is used.
e.g
CREATE PROCEDURE [dbo].[spr_SP1]
@ColA INT,
@AutoID INT OUTPUT
AS
BEGIN
INSERT INTO TableA ( ColA )
VALUES ( @ColA )
SELECT @AutoID = SCOPE_IDENTITY();
END
When adding the parameter to the command on the code, usually...
About Me
- Steven Luck
- Is an ordinary man, with a little knowledge to share and high dreams to achieve. I'd be glad if I can help others, 'coz the only thing for the triumph of evil is for a good man to do nothing.
Popular Posts
-
Have just got a lovely blog award, my second one, from a friend, Mona ^^ But there is a rule to accept this award.. hehehe... Post it on yo... -
Are you learning Assembly language , and confused about how to compile assembly file? TASM20 is one of assembly compilers that works with ... -
Error : Xml data type is not supported in distributed queries. Remote object ' <ServerIP> \ <ServerInstance> . <Database...
-
Continuing my last post about compiling and running assembly file , it is actually possible to easier compile and run assembly file from Tex... -
If you are trying to update a table containing XML column via Linked Server in SQL Server, and you are not able to, you are not alone. There...