Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Raise error On 2005 Functions

Author  Topic 

aoriju
Posting Yak Master

156 Posts

Posted - 2009-03-19 : 01:55:15
Dear All
how to raise error messages on 2005 scalar or tale values functions

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2009-03-19 : 02:02:09
The function on this link generates and error at the end:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519

Look at the code after the label "Error_Exit"


CODO ERGO SUM
Go to Top of Page

aoriju
Posting Yak Master

156 Posts

Posted - 2009-03-19 : 02:11:04
can write as Simple like Raiserror(16,1,'Failed');
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2009-03-19 : 16:30:07
quote:
Originally posted by aoriju

can write as Simple like Raiserror(16,1,'Failed');



The point is that Raiserror does not work in a function.



CODO ERGO SUM
Go to Top of Page
   

- Advertisement -