Learn to share

   I know that some of you might want to do like me, export database diagram to be executed in other server. This case would meet when we want to have a very blank database but remain all database schema of an existing database one. Normally we can do a back up then restore it as a new name then run the script to truncate all data in every tables but it will be difficult if it was build with diagram. I have found on the net the sample on SQL Server 2000 and also 2005. It is a very helpfull for my case as I need to re-create database schemas on my new blank database. 1. SQL 2000 There have 2 store procedures and a function is needed ufn_VarbinaryToVarcharHex CREATE FUNCTION dbo.ufn_VarbinaryToVarcharHex (@VarbinaryValue varbinary(4000)) RETURNS Varchar(8000) AS BEGIN Declare @NumberOfBytes Int Declare @LeftByte Int Declare @RightByte Int SET @NumberOfBytes = datalength(@VarbinaryValue) IF (@NumberOfBytes > 4) RETURN Payment.dbo.ufn_VarbinaryToVarc...

       I think you would know sometime about Cloud Storage. Cloud Storage is a model of networked online storage where data is stored on multiple virtual servers, generally hosted by third parties, rather than being hosted on dedicated servers.It mean that the storage at somewhere on the net There have several free cloud storage on the net available currently like:          It is one of the most popular cloud services that lets you store, sync, and share files over the Internet         With Dropbox you can have 2GB of free storage for your files and medias. You will have an additional 250MB on bonus space if you refer your friends to join and install Dropbox. You can have the storage up untill 8GB.            It supports Windows, Mac and Linux computer operation systems, as well as iPhone, iPad, Android and BlackBerry.   ...

     I have been taking long time to seek on the net for the old version of web development language in ASP for a file management. I know that have not much right now as the new technology is already covered all of new web development.  Thanks to  maarten  for his effort working on a  Easy content File Manager . It's a great tools which can help me to meet the need in my old application request. 

There might have many way to manage running number as invoice or other sequence number generating but I would like to bring two among them. With SQL Server, I would like to show you about what I have been implemented in my previous application in generating invoice running number. 1. Using table to store last running number, store procedure and transaction We firstly need to create a running number storage table        Create table tblInvoice with fields           InvoiceNumber (int, not null, primary key)           InvoiceType (char(3)). Then create store procedure which is used to manage its value PROCEDURE [dbo].[UDP_GETINVOICENUMBER] @invoice_type as char(3), @invoice_number AS BIGINT OUTPUT AS BEGIN SET NOCOUNT ON; BEGIN TRANSACTION UPDATE tblInvoice SET @invoice_number=InvoiceNumber=InvoiceNumber+1 WHERE(InvoiceType=@invoice_type) COMMIT TRANSACTI...

Good afternoon,     Since long that I have some photos on flickr to share with my friends on the net. We used to review our old memory with those. Sometime we sad, sometime we laught... It's a very great to look back to the our old time... I got in mind while starting the blog, how can I integrate those flickr picture in it. I start to search on the net and finally I found few helps which make me archive the goal. The would have many possility but I keep showing only two amoung them: First one(integrate flickr slideshow):         The following step can guide you to make it done. You need to create flickr account(in case that you did not have it previously) , then upload photos or videos as needed and it is needed to set its privacy to Public   (anyone can see them)  so that everyone on the net can see it otherwise it will not show in the widget. Once you have those photo...

    How are you lately? This is my first time that I start to write in this blog. It has been very long that I have been involve in computer science but I rarely write any article. It's just because I do not really like writing the text.  I write this because I wanna to start on my writing skill. I am not good in English so I am sure there will have huge error can be met in this blog.