clear markdown compare help best fiddles feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3601498 fiddles created (47967 in the last week).

CREATE TABLE dbo.Jason ( id integer PRIMARY KEY, jason nvarchar(max) NOT NULL ); INSERT dbo.Jason (id, jason) VALUES (1, N'');
1 rows affected
 hidden batch(es)


DECLARE @char nvarchar(max) = N'X'; DECLARE @id integer = 1, @jason nvarchar(max) = REPLICATE(@char, 4 * 1024 * 1024); -- 8MB SET STATISTICS TIME ON; UPDATE dbo.Jason SET jason = @jason WHERE id = @id;
SQL Server Execution Times: CPU time = 15 ms, elapsed time = 343 ms. 1 rows affected
 hidden batch(es)