In a world driven with data all over, it is very easy to get duplicate data. The nightmare of any database table designer is to create a table with the possibility of duplicate data insertion. To overcome the problem of duplicate rows, SQL primary key is used to uniquely identify each row. SQL Primary Key […]
Install SQL Server Express and SQL Server Management Studio
SQL server is one of the most used databases in the world. Also, SQL server’s performance is well known to the world. In order to understand any system the best way is to try out the system. We will also do the same. Let us install SQL Server into our Windows system. Install SQL Server […]
SQL Select Top
SQL Select Top SQL SELECT TOP clause is very useful when dealing with a huge set of data or tables with a huge amount of data. This clause is used to restrict the number of records to return a result set. The SELECT TOP clause can be used in two ways. By providing the number […]