You might see some examples on the net in which a semi-colon is used as a separator between multiple sql statements. This is still a requirement in some databases, but not generally, in SQL Server or MS Access. It can be used and recognized, but it is not necessary in most cases. In one case, in particular, in SQL 2008, the MERGE statement must be terminated by a semi-colon.
There are times when you might be using multiple sql statements and you find that they are not behaving the way they should. In these cases, it might be prudent to put this after each statement:
This is just to make sure each one gets executed and completed before going on to the next one. This also is very helpful for batches, when you have multiple statements that need to be run all at one time.
All Things DotNet Discussed – Winforms/ASP.Net/SharePoint/WPF