SQL - 如何检查数据类型的溢出

Question

我想检查 SQL 数据库中列的特定数据类型是否溢出。这是我需要放入 SQL 中的文本:

"overflow happened when the value is out of the interval of a column's data type"

Answer 1

像这样的东西适用于 SQL Server ......

DECLARE @userInput NVarChar(100) = '129387918279387987123123';
DECLARE @value Int;

BEGIN TRY
  SELECT @value = CONVERT(Int, @userInput);
END TRY
BEGIN CATCH
  PRINT 'Overflow happend when the value is out of interval of column''s data type';
END CATCH;