Front Page Recent
In addition to new DATETIME data types introduced in MSSQL 2008 there are geography and geometry data types introduced - useful for storing and manipulating geodetic data. Geometry data type is used to store flat map data like points, lines, and shapes [ ... ]
MSSQL 2008 introduces several new DATETIME datatypes for T-SQL: TIME, DATE, DATETIME2, DATETIMEOFFSET. It is obvious that TIME and DATE provide the ability to store separately DATE and TIME parts of DATETIME. It was not possible to do in previous versions of MSSQL, however [ ... ]
An interesting issue I came into recently. Suppose you have a search procedure - which consists of some SELECT query which gets a query phrase as a parameter and searches through a table coulumn using LIKE [ ... ]
Sometimes we need to search and replace a text value in the entire table. The column in question is of TEXT or NTEXT datatype. T-SQL REPLACE function does not work with TEXT/NTEXT datatype. Instead we have to use several other functions [ ... ]
BBC came out with an article today Identity 'at risk' on Facebook which discusses potential stealing of user data by 3rd parties applications of Facebook Development Platform: When you add an application [ ... ]
How to print the current row number in an ASP.NET Repeater control ? The easiest way to autonumber rows in Repeater is to use markup or ItemDataBound event [ ... ]
Ever wondered why does .NET winform application takes so much memory on startup ? It is obvious that most of this memory is not in use. The reason is that JIT compiler and the whole winforms engine is loaded into the process [ ... ]
he following method will flash the title bar or taskbar button or tray icon. Need to wrap a method imported from user32: FlashWindowEx [ ... ]
I recently went through several posts I had made on one of the development forums back then in 2005. I've found one of them interesting and want to repost it here. The question went like this: How can I calculate euler number with recursion [ ... ]
Very often during development process we need to remove last character from a string. It could be a trailing slash or trailing comma resulted as a side effect of building delimited strings [ ... ]
|
