Sample Header Ad - 728x90

sql bigger parameter then specyfied - no error - just taking substring? why?

0 votes
1 answer
70 views
I have some sql procedure (MSSQL 2019) if relevant
Create PROCEDURE [dbo].[test] @tmp varchar(32)  AS
print @tmp
why when i do
EXEC	@return_value = [dbo].[test]
		@tmp = N'SSL99999999999999999999999999999900000006785999999999999999'
I se it use 32 chars substring in @tmp ? SSL99999999999999999999999999999 And no exception that string or binary data would be truncated as i expected ? Can i turn on such behavouur ? i would need this if possible ;) Thanks and regards !
Asked by Dorian (113 rep)
Feb 13, 2024, 08:18 AM
Last activity: Feb 13, 2024, 09:20 AM