Skip to content
← LINQPad Feature Suggestions

I suggest you ...

LINQPad Feature Suggestions

Categories

(thinking…)

Can I get more than 1000 characters in the parameters section of the SQL output pane?

I have been using LINQPad to deploy a few large strings directly into a database table, but I recently needed to get the full script of what was being generated so I could deploy in an environment without LINQPad. When I opened the SQL output pane, the declaration which held the variable containing my 9 KB string was limited to the first 1,000 characters. Is there somewhere I can configure LINQPad so it will not truncate the SQL output as shown below?

-- Region Parameters
DECLARE @p0 VarChar(1000) = 'CNV'
DECLARE @p1 NVarChar(1) = N'declare @interfaceId int = 70;

... snip ...

JOIN PROJECTPRODUCTVENDOR...' -- (first 1000 characters/9176 shown)
-- EndRegion

24 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
arcain shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • White commented  ·   ·  Report

    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?