创建 .exe 文件,该文件接受参数、生成并执行 SQL 查询,SSMS 2005
我正在使用 SQL Server Management Studio 2005 编写在数据库上使用的脚本。使用同一数据库的其他人可以查询它,但没有 SMSS,无法一次执行多个批次,这是非常有限的。
我希望能够创建可以提供给其他用户的 .exe 文件,这基本上是简单的布什按钮。他们会提示输入某些参数并将它们注入我的脚本中,然后运行它。有人告诉我,如果我有视觉管理工作室,我就可以做到这一点,但可惜的是,我没有。
有没有什么方法可以只使用 SSMS(以及其他任何东西,只要它是免费的)就可以做到这一点,或者我绝对必须购买更多软件?我愿意使用任何编程语言来完成它。
I am using SQL Server Management Studio 2005 to write the scripts I use on a database. Other people using the same database can query it, but do not have SMSS and cannot execute multiple batches at once, which is very limiting.
I'd like to be able to create .exe files which I can give to other users, which would basically be simple bush-buttons. They would prompt for certain parameters and inject them into my script, then run it. I am told I could do this if I had Visual Management studio, but alas, I do not.
Is there any way to do this with just SSMS (and anything else as long as it's free) Or do I absolutely have to buy more software? I'm willing to use whatever programming language will get it done.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
获取 Visual Studio Express 版本之一 - 它们是免费的并且非常适合您想做的事情。
Get your hands on one of the Express editions of Visual Studio - they're free and perfectly suited to what you're wanting to do.