CODEWITHSUNDEEP
sqlsql-server
Venaikat
Venaikat

Reputation: 197

how to display alert message box in sql server using stord procedure ,if condition not satisfied

I wanted to display a message box in .net(front end) using stored procedure in sql server if conditon not satisfied. i wanted to write the condition in stored proc only to display the message box in front end.

Thanks in advance, Venkat.

Upvotes: 1

Views: 22828

Answers (3)

Hassan
Hassan

Reputation: 1433

You can Use the RAISERROR method on your Stored Procedure

Check this http://support.microsoft.com/kb/321903

Upvotes: 0

Joe G Joseph
Joe G Joseph

Reputation: 24046

You can make the stored procedure return something using OUTPUT parameter based on the query in the stored procedure..

BAsed on the OUT PUT value , you could display the message box

Upvotes: 0

podiluska
podiluska

Reputation: 51494

You can't.

Write your stored procedure to return an appropriate value, according to the result, and make your .net front act on that result accordingly,

Upvotes: 2

Related Questions