2017-04-24
1,122 reads
T-SQL
Should I Type * or 1 With the EXISTS Logical Operator
In my project I see that people writes different things with EXISTS logical operator (EXISTS (SELECT StarOrOne FROM...)). They are "*", "1" and even "TOP 1 1" or "TOP 1 *". The aim of this article to give a good explanation which option is the best.
2020-01-24 (first published: 2017-04-24)
14,876 reads
2017-04-21
1,249 reads
2017-04-14
1,201 reads
Nuance of datetime data type in SQL Server
One of the most confusing data types in SQL Server is the datetime datatype.
2017-04-13
2,335 reads
2017-04-06
1,473 reads
2017-03-23
1,099 reads
Adding Years, Months and Days
Adding Years, Months and Days to Years, Months and Days, with Bonus UK Public Holiday calculation.
2017-03-14
3,195 reads
2017-03-02
1,181 reads
2017-02-28
1,264 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers