Some sweet goodnight message for your love one

I know some of you, event me, sometime we have no idea what we should write in term of sort message for our love one. Time is running fast and thanks for the technology which enable us to them to communicated to each other. Previously, I and some of you might use letter to send to each other and it takes sometime lot long to reach or event lost by some other means.

Right now, just few seconds, message can deliver to your lover in their hand using Short Message Service(SMS), Line, Facebook, Hangouts, Skype, …

Below are some sweet message for your love one, I have collected from some various online resources.

  1. No words powerful to show my love. There are no words powerful enough to show my feelings for you, but trust me, I love you I really love you from the bottom of my heart.
  2. Can’t wait to be in your arms again, my love. Good Night.
  3. Looking at the dark skies of the night lit up by the sexy glitter of the stars and the romantic glow of the moon, makes me think of just one thing – wish you were here with me. I love you, good night.
  4. Everyday I love you more than I did the day before. I can’t image how I could possibly love you more than I do but somehow everyday I manage it. I can’t wait for tomorrow to love you more again.
  5. Read More

Concurent Invoice Number with SQL Server Store Procedure

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 TRANSACTION
END

2. Using Identity field
This mean that we need to use the function SCOPE_IDENTITY() function to get the recent added row.
Read More