{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 Melony? 的问题《Prompt for parameters with SQL Management Studio》','https://www.manongdao.com/q-253902.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
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.
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?
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.