Tuesday

Custom Error in MS-SQL server by RAISERROR (TSQL)


--Add message
exec sp_addmessage @msgnum = 60000, @severity = 16,
@msgtext = 'The record has been modified already by other process',
@lang = 'us_english';
go
-- sample of usafe
if @CurrCheckSum <> @xmlCheckSum
RAISERROR (60000, 16, 1)
ELSE

more...

No comments:

here is powershell script on how to get list of files from changesets associated with one tfs task

$dllPath = "C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\Common7\IDE\CommonExtensions\Microsoft\TeamFoundation\...