sql server error handling - SQL Server Forums

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

sql server error handling

Author

Topic

TajKazi
Posting Yak Master

101 Posts

Posted - 2014-10-16 : 09:15:43

set @v_IsValidApplication = (select count(*)
from tbl_error_messages
where ApplicationId = 94

how to write this oracle code in sql server 2008 where we are using default error messages and default error handling which is present in sql server

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-10-16 : 12:04:08

select @v_IsValidApplication = count(*)
from tbl_error_messages
where ApplicationId = 94

I don't understand what you are asking about error handling here.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

TajKazi
Posting Yak Master

101 Posts

Posted - 2014-10-17 : 00:00:16

this is an oracle code.... for user made error table, but in sql i have write this code for default error msg table.....

TajKazi
Posting Yak Master

101 Posts

Posted - 2014-10-17 : 03:29:34

i got solution..

select count(*)
from sys.messages
where Message_Id = 94

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources