Skip to main content

T-Sql: Error Handling Solution

The following code can be the simple solution for error handling problems in the SQL Server:
Declare @ErrorCode int
Select @ErrorCode = @@Error
If @ErrorCode = 0
Begin
--Some statement
Update …
Select @ErrorCode = @@Error
End
If @ErrorCode = 0
Begin
--Another statement
Insert …
Select @ErrorCode = @@Error
End
If @ErrorCode = 0
Begin
--Another statement
Update …
Select @ErrorCode = @@Error
End
Return @ErrorCode


More information:
http://msdn2.microsoft.com/en-us/library/aa175920(SQL.80).aspx

Comments

Popular posts from this blog

Reflector for .Net - amaizing how open your .Net source code

Reflector for .Net - Reflector is the class browser, explorer, analyzer and documentation viewer for .NET. Reflector allows to easily view, navigate, search, decompile and analyze .NET assemblies in C#, Visual Basic and IL. At same site there are also other interesting tools like: Resourcer for .NET - Resourcer is an editor for .resources binaries and .resX XML file formats used with the .NET platform Mapack for .NET - Mapack is a .NET class library for basic linear algebra computations.

Must To Have Utilities

FileMon - FileMon monitors and displays file system activity on a system in real-time. Note: Filemon and Regmon have been replaced by Process Monitor on versions of Windows starting with Windows 2000 SP4, Windows XP SP2, Windows Server 2003 SP1, and Windows Vista. Unlocker - The solution for "Cannot delete file: Access is denied" error message. Dependency.exe - Dependency Walker is a free utility that scans any 32-bit or 64-bit Windows module (exe, dll, ocx, sys, etc.) and builds a hierarchical tree diagram of all dependent modules. SCDL version 1.1 - Generates source code for config sections based on an XML sample, also creates the XSD schema for the section. Expresso - Regular Expression Editor and Tester

Post on behalf of Facebook Page using Graph API

Assuming someone would like to give your permissions to post on his Facebook Pages :-), you need to do following things: Ask for the publish_stream and manage_pages using Facebook Authentication Dialog Get Page Access Token. Such access token can be retrieved by issuing an HTTP GET to /USER_ID/accounts with the manage_pages permission. This will bring you list of the pages and access tokens of such pages. You also can you /PAGE_ID?fields=access_token request to get access token for specific page. (Reference - https://developers.facebook.com/docs/reference/api/page/) Once you have page access token you will be able to post. Posting can be done using following parameters: curl -F 'access_token={ACCESS_TOKEN}' \ -F 'message={MESSAGE TO POST}' \ https://graph.facebook.com/{PAGE}/feed