SqlError.Number descriptions

2019-02-23 16:11发布

问题:

Where i can get all the descriptions of the SqlError.Number collection? This are throwed by SqlException

回答1:

SELECT Description FROM master..sysmessages  


回答2:

From sys.messages in your database. Since you can add your own errors in SQL Server (via sp_addmessage), there is no definitive list. Also, the pre-defined list (below 50000) can differ (grow) per database version.

(or do you just mean .Message on each SqlError instance?)



标签: c# .net sql tsql