Maximum length of expressions, variables, and stored procedure arguments

The maximum size for expressions, variables, and arguments passed to stored procedures is 16384 (16K) bytes, for any page size for character or binary data. You can insert variables and literals up to this maximum size into text columns without using the writetext command.