I was asked by a friend of mine on how to create a trigger that would trace the changes that a user did to a table. So i checked my bookmarks and give him this link http://www.nigelrivett.net/SQLTriggers/Triggers_2_Creating_Audit_Trails.html Hope to Get some of your opinions or maybe improvements on...
In one of the website I have developed, we feature random products displayed on a webpart. This can be done several ways either of the code behind or via t-sql but I think the simplest way to do it is via t-sql with the help of Guid columns. Globally Unique Identifier or GUID is a randomly generated...
Here's a tool that im using for some of my projects. What it does is it Automate the Generation of Stored Procedures for Your Database. You just have to execute a querry like this EXEC pr__SYS_MakeUpdateRecordProc 'Order_Details', 1 and it will automatically generate a stored procedure for the table...
During my last post try to query the actual size of the logfile, and today i'm going to share a script i found months ago at the microsoft site. I cant find the original link.... Notes: Be sure that you have a backup of your database so that if something goes wrong you have something to get back into...
dwarvend, a former teammate in my frist company once asked me about data paging large resulsets in ASP.NET. Data paging in SQL Server 2005 is relatively easy with new RowNumber feature but supporting dynamic sorting is little tricky. I have this executable to script to demonstrate this sorting. --check...
When you are developing software product to be catered to diverse customers, it must be a standard to localized your software. With .NET this has never been easy, on .NET 2.0 its even easier with striongly typed resource files. But localizing application must be part of the architectture and should not...
Posted to
Rodel E. Dagumampan
by
rdagumampan
on
11-07-2006
Filed under:
Filed under: .NET, sql server , ASP.NET, usability and design, Development Process, how to, L10N, localization, scripts, stored procedures, user interface, sql, sequel server