SQL Serer 2005 [英] Sql serer 2005

问题描述

大家好，
如果通过存储过程或sql函数满足特定条件，我们可以显示消息或某种类型的提示吗???? :doh:
我的应用程序在VB.NET中.我正在使用SP更新数据库，但是同时它应该检查有效数据，并且如果数据验证失败，奎里(Querry)应该给我错误消息...

Hi all,
can we display message or some type of prompt, if specific condition get satisfied through store procedure or sql function???? :doh:
My application is in VB.NET. I am using a SP to update my database,but at the same time it should check valid data and if data validation failed querry should give me error message...

推荐答案

您可以使用PRINT玩一点或提供一些虚拟列(即，选择"abc"作为some_dummy_column)并查看SqlCommand的输出.我能够在delphi上做到这一点
(例如，我能够在Backup上看到进度，但它是内置的)，但尚未在.NET上对其进行测试(但它是ADO，因此也应该可行).

You can play a little bit with PRINT or provide some dummy column(ie. select ''abc'' as some_dummy_column) and see what is output from SqlCommand. I was able to do this on delphi
(i was able to see progress on Backup for example, but that was built in) but haven''t tested it on .NET (but it is ADO so it should be also posible).

这篇关于SQL Serer 2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！