You are currently browsing the monthly archive for abril 2008.


FONTE: (SQLServerCentral) http://www.sqlservercentral.com/columnists/jSebastian/3122_printver

Introduction

If you have ever worked on an order processing application, you would realize that saving a modified

sales order is little tricky. There may be new rows added to the sales order. There may be rows which are

updated and there may be rows that should be deleted. If you have the freedom to delete all the rows from

order details table and re-insert everything, you are lucky. But many of the times you cannot simply delete

the order details table because there may be additional information like Quantity-picked etc, which is

updated from other parts of the application. In those scenarios, you need to perform a

DELETE-UPDATE-INSERT operation to save the information correctly. The following is the pseudo code

that I had used in my stored procedure.

Continue lendo »

Anúncios

Olá pessoal a partir de agora vou tentar postar alguns artigos que achar interessantes