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,376 reads
2015-10-22
1,822 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,225 reads
2008-07-03
10,685 reads
DCAC recently had a custom PowerPoint template built for us. We use PowerPoint for...
Speaking Engagements Check out my new Event Calendar, to see my upcoming and past...
By James-Serra
Introduced in April 2019, Databricks Delta Lake is, in short, a transactional storage layer...
Comments posted to this topic are about the item More Network Restrictions, which is...
CREATE TABLE #Source ( PlanId BIGINT, StartDate DATE, EndDate DATE ) GO CREATE TABLE...
I want to be able to: encrypt a password column display characters x &...
Ask SSC