MS SQL SERVER QUERY ERROR CONTROL (TRY CATCH KULLANIMI İLE HATA YAKALAMAK)




BEGIN TRY




SELECT *, Phone / 2 FROM  [NORTHWND].[dbo].[Shippers]

END TRY
BEGIN CATCH
SELECT  ERROR_MESSAGE() AS HATA_MESAJI,
ERROR_NUMBER() AS HATA_NUMARASI,
ERROR_LINE() AS HATA_SATIRI
END CATCH

Yorumlar