Introduction TOP is one of the many syntactical operators available in T-SQL and at a first view, it could seem very simple and not particularly interesting. According to the official documentation, it “limits the rows returned in a query result set to a specified number of rows or percentage of rows”. The following is the […]
2019-06-04
4,626 reads
2015-10-22
1,828 reads
There are times when you don’t what to return a complete set of records. When you have this kind of requirement to only select the TOP X number of items Transact SQL (TSQL) has the TOP clause to meet your needs. In this article Greg Larsen explores how to select a subset of data from a record set.
2015-04-16
9,580 reads
2014-05-09
2,198 reads
2013-06-04
2,391 reads
2013-05-30
2,134 reads
2009-03-18
5,226 reads
2008-07-03
10,686 reads
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Triggers. Blech. Triggers are a really really cool feature of SQL Server, that are...
By Cludio-Silva
We have seen how we can export and save the results to a folder...
Hi I have one doubt in ssis I want delete the data in the...
Comments posted to this topic are about the item Database Extended Properties
Ask SSC