SQL 如何在 MSSQL 中声明 VARCHAR 变量
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/22818025/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-09-01 01:33:04 来源:igfitidea点击:
How to declare VARCHAR variables in MSSQL
提问by Vignesh Subramanian
I want to declare a VARCHARvariable in MSSQL that can hold this
我想VARCHAR在 MSSQL 中声明一个可以保存它的变量
set @RaiseErrorMessage =
('ErrorNumber='+(cast((select ERROR_NUMBER()) as varchar(100)))+
,ErrorSeverity='+ (cast((select ERROR_SEVERITY()) as varchar(100)))+
',ErrorState='+(cast((select ERROR_STATE()) as varchar(100)))+
',ErrorLine='+(cast((select ERROR_LINE()) as varchar(100)))+
,ErrorMessage='+(cast((select ERROR_MESSAGE()) as varchar(100))))
How should the declaration look for an variable like this? I tried
声明应该如何寻找这样的变量？我试过
declare @RaiseErrorMessage varchar
but it didn't help.
但它没有帮助。
回答by dsolimano
You'll need to declare the length of the variable:
您需要声明变量的长度：
DECLARE @RaiseErrorMessage VARCHAR(500)
SET @RaiseErrorMessage=' ...... '
