SQL Server

April 6, 2011

What data type to use for representing currency in C# and Sql Server 2005/2008?

By |2011-04-06T22:51:19+00:00April 6th, 2011|Categories: ASP.NET, SQL Server|Tags: , , |

This post will be short and sweet.  What data type should you use to represent currencies in C#? - Decimal If you use double, you will end up with rounding errors on more precise numbers, and if you are writing applications that support multiple currencies, namely currencies that use very large numbers, such as the Indonesia [...]

February 2, 2011

Simple SQL Cursor Example

By |2011-02-02T22:43:43+00:00February 2nd, 2011|Categories: SQL Server|Tags: , |

If you're reading this blog, chances are, you know how to write/use a SQL cursor. But this is more for my benefit, and maybe even yours. Just a quick cursor example, so that I can easily reference the syntax if I ever need to quickly look it up, since I always seem to forget it.  Enjoy.DECLARE [...]