Technology Knowledge

In SQL Server, it has many system store procedures that are so interesting. It is really easy for developers to view script from  sproc, view, and function by SQL server tool. Read more »

I  use .net to developed website on window xp sp2 and then i move to use window vista. At that time it really annoy me because the iis 7 is setup incorrectly.

It take me one day try to find the solution then i got it. here is the guide to setup IIS7 on Vista.

IIS7 setup

Two weeks ago when i working on my project i face the problem with delete duplicate rows in t-sql.
I try to write long script to do it. However, it is just two lines of script.
We can delete duplicate rows by identify the duplicate field and unique field.
As i want to delete books that have many classifications to keep only one.

DELETE b1FROM books b1, books b2

WHERE b1.code = b2.code and

b1.classification_id > b2.classification_id