01-28-2022 01:52 AM
Hello everyone,
i have big trouble with send query to MSSQL. It´s a stored procedure. First procedure is InsertNewProduct and everything works fine, but every other next procedure has same error. I tried to solve this for last two days and I don´t find answer anywhere on forum. I know, that´s not problem with LV, but with SQl,but create query in LV is very specific, so please help me.
ALTER
PROCEDURE
[db_procedure].[InsertOperationStatus]
-- Add the parameters for the stored procedure here
@SerialNumber
varchar
(
MAX
) =
NULL
,
@WorkplaceRegistrationNumber
varchar
(
MAX
) =
NULL
,
@StatusId
varchar
(
MAX
) =
NULL
,
@ActiveUserRightId
varchar
(
MAX
) =
NULL
,
@ModifyUserId
varchar
(
MAX
) =
NULL
,
@
TimeStamp
varchar
(
MAX
) =
NULL
,
@TimeZone
varchar
(
MAX
) =
NULL
,
@ErrorCode
int
=
NULL
OUTPUT
,
@ErrorText nvarchar(250) =
NULL
OUTPUT
02-03-2022 03:39 AM
Hi!
Just a hint:
I like this style very much, since it's clean and simple:
Note: