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

Post a Comment

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.
Post a Comment
Read more

Asynchronous pages in C# - When to Use It?

When do we need asynchronous page in ASP.net. Suppose you have a website with two web pages. One is your home page which display's a greeting, and the second page displays a large dataset from a database. You have 25 threads in your thread pool. 25 people simultaneously are accessing the database query page, and one additional person comes onto the site to see the home page which has static content on it. http://davidjberman.com/blogs/csharp/archive/2007/08/13/how-to-create-asynchronous-asp-net-pages-using-c.aspx
Post a Comment
Read more

Dynamic Data Error - "'DropDownList1' has a SelectedValue which is invalid because …"

During my first investigation of Dynamic Data Support at .NET 3.5 environment, I've found that even Microsoft has bug :-))) After the following great instructions of following screen-cast I've finished in few minutes with applications that allows me to maintain all my database tables. The problem is that already at third screen I've played with I got following error message: 'DropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items. Fortunately, I'm not the first who is plying with Dynamic Data at .NET 3.5 so at this blog you can find fix and good explanation of this bug.
Post a Comment
Read more