GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[UpdateEditor]
(
@tblUserIdParam nvarchar(255), - Specify length of tblUserIdParam parameter
@UniqueID uniqueidentifier
-- @RowIdHidden int
)
AS
BEGIN
SET NOCOUNT ON
update tblTempForEditor set tblUserIdParam=@tblUserIdParam where UniqueID=@UniqueID
chintanpshah
All-Star
19058 Points
3273 Posts
Re: I only get first letter inserted when I call stored proc
Jul 16, 2009 06:25 AM|LINK
Specify parameter lenght in SP.
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[UpdateEditor]
(
@tblUserIdParam nvarchar(255), - Specify length of tblUserIdParam parameter
@UniqueID uniqueidentifier
-- @RowIdHidden int
)
AS
BEGIN
SET NOCOUNT ON
update tblTempForEditor set tblUserIdParam=@tblUserIdParam where UniqueID=@UniqueID
END
My Software Website