问题描述
我真的很喜欢Visual Studio中的SQL工具,很少使用SQL Server Management Studio.我正在更新另一个开发人员编写的查询,他使用了SQL Management Studio.由于某种原因,Visual Studio正在格式化查询,这使其难以使用.
I really like the SQL tools within Visual Studio and very rarely use SQL Server Management Studio. I'm updating queries written by another developer and he used SQL Management Studio. For some reason Visual Studio is formatting the query, which makes it hard to work with.
一些查询中有参数,当我在Management Studio中运行查询时,出现错误.在Visual Studio中,我习惯于提示我输入参数.有什么办法可以告诉Management Studio提示我输入这些值?
A few of the queries have parameters in them and when I run the query in Management Studio I'm getting an error. In Visual Studio I'm used to it prompting me for the parameters. Is there a way I can tell Management Studio to prompt me for those values?
推荐答案
如果右键单击proc并选择"EXECUTE",SSMS将提示输入存储过程的参数.否则,否,它不会提示输入参数.
SSMS will prompt for parameters for a stored procedure, if you right click the proc and select "EXECUTE". Otherwise, no, it will not prompt for parameters.
这篇关于使用SQL Management Studio提示输入参数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!