← Customer Feedback for LINQPad Settings and activity 1 result found Can I get more than 1000 characters in the parameters section of the SQL output pane? 24 votes Vote Vote Vote Vote We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close 1 vote 2 votes 3 votes Remove votes You have left! (?) (thinking…) 1 comment · LINQPad Feature Suggestions · Delete… · Admin → How important is this to you? Not at all You must login first! Important You must login first! Critical You must login first! We're glad you're herePlease sign in to leave feedback Signed in as (Sign out) Close Close An error occurred while saving the comment White commented · March 08, 2022 · Edit… · Delete… Can I add that I believe what's displayed is not what's actually run? I think? I get the following SQL out after updated an nvarchar(max) column... DECLARE @p0 Int = 1 DECLARE @p1 NVarChar(1000) = 'really long string...' -- (first 1000 characters/1610 shown) UPDATE [Item] SET [Data] = @p1 WHERE [Id] = @p0 GO If this was in fact a nvarchar(1000) variable, wouldn't my data be truncated? Save Submitting...
Can I add that I believe what's displayed is not what's actually run? I think? I get the following SQL out after updated an nvarchar(max) column...
DECLARE @p0 Int = 1
DECLARE @p1 NVarChar(1000) = 'really long string...' -- (first 1000 characters/1610 shown)
UPDATE [Item]
SET [Data] = @p1
WHERE [Id] = @p0
GO
If this was in fact a nvarchar(1000) variable, wouldn't my data be truncated?