Bujar Ademi

Bujar Ademi

Windows Programmer

Database
SQL query remove duplicate rows from table
Bujar Ademi

It may happen times to times you need to delete duplicate rows from a table. There are many options to do that. I will write on my blog one of my option that I am using often to remove duplicate rows from a table.

Let’s say we have a…

readmore →
UPDATE/DELETE with INNER JOIN
Bujar Ademi

Many time I had problem to update or delete rows from one table depends from another table (inner join). Like we make select from two or more tables with inner join in the same way we can make also update or delete.

Let’s take an example where we have…

readmore →
Introduction to Relational Database
Bujar Ademi

In this article, I will try to demonstrate what a relational database is, and how to properly design your database to store informations in it.
A database stores data in an organized way so that it can be searched and retreived later. A database is collection of one or more…

readmore →
Visual Basic 2005 – Add file to sql table

During a project that I’m doing now, I saw that many programmers have their photos or any document to keep them in the database and whenever they need to open it. In the project I’m working for my company we need to save our documents (images, word documents…

readmore →
© 2014 Bujar Ademi. All rights resevered.