SQL Server Rounding Tips and Tricks
This article shows different options to use the rounding functions in SQL Server.
2020-04-17 (first published: 2016-09-20)
23,772 reads
This article shows different options to use the rounding functions in SQL Server.
2020-04-17 (first published: 2016-09-20)
23,772 reads
Snippets will allow you to code faster by inserting chunks of code with few key strokes.
2018-08-17 (first published: 2016-04-07)
10,508 reads
Using wildcard to find patterns in strings going from the basics to some more complicated conditions.
2017-02-10 (first published: 2015-09-29)
18,973 reads
Set-based programming doesn’t mean “no loops” or a single statement. Finding out the best ways to traverse a full hierarchy.
2016-10-07 (first published: 2015-07-27)
24,238 reads
2015-11-18 (first published: 2015-10-29)
933 reads
Calculating working hours can be painful due to all the variances that they imply. This function will calculate working hours between 2 dates which might include time. There's an option to use a holidays table that will vary in each environment.
2015-10-22 (first published: 2014-05-22)
3,711 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
The Utah Jazz experienced arguably their utmost modern acquire of the year in excess...
No person would create the situation that a eye-catching video game of basketball was...
Chicago Bulls vs. Charlotte HornetsCharlotte, North Carolina; Wednesday, 7:30 p.m. ESTBOTTOM LINE: Charlotte is...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers