Using a number’s table, you can break down every value in a column into one character per row, and then do some analysis. In our case, I want to find a bad character, by eliminating known acceptable characters.
2019-04-05
2019-04-05
1,674 reads
This is going to be a bit of a brain storming post that comes from an interesting question that I was asked today: “I’ve got a table with a ID code field, now some of the rows have a value in that field and some are NULL. How can I go about filling in ...
2019-03-30
It is the fourth post on series related to installation and configuration of SQL Server client tools required. This series is for professionals who start their journey with SQL Server administration and also for those who want to extend and structure...
2019-03-30
Question: How Does QUOTED_IDENTIFIER Works in SQL Server?
Answer: If you search on the internet, you may find quite lots of notes about it. So this blog post, explains it in very simple words.
2019-03-30
In this article, we’ll look at some alternatives to using SQL cursors which can help to avoid performance issues caused by using cursors.
2019-03-30
2019-03-14
973 reads
T-SQL window functions have been a fantastic addition to the T-SQL language. In this article, Kathi Kellenberger reviews how optimizations available in SQL Server 2019 can improve the performance of these functions.
2019-03-07
2,782 reads
In this tip we look at T-SQL code that can be used to determine the greatest common divisor for a set of integers.
2019-01-16
2,635 reads
Is there a difference between using TOP and MAX/MIN to return and end value to a table?
2020-08-14 (first published: 2018-12-17)
7,892 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers