Function for String Occurences Count
This function is used to get the particular string occurences count from the given input string.
2015-01-16 (first published: 2014-12-16)
1,133 reads
This function is used to get the particular string occurences count from the given input string.
2015-01-16 (first published: 2014-12-16)
1,133 reads
This script allows the DBA to quickly determine if a deny statement is stopping a user from accessing db objects.
2015-01-14 (first published: 2014-12-17)
7,034 reads
This function is used to calculate the actual unit of conversion for temperature.
2015-01-09 (first published: 2014-12-11)
1,023 reads
This function is used to calculate the actual unit of conversion for angle.
2015-01-06 (first published: 2014-12-10)
656 reads
This function is used to calculate the actual unit of conversion for area.
2015-01-02 (first published: 2014-12-10)
694 reads
This function is used to calculate the actual unit of conversion for mass.
2015-01-01 (first published: 2014-12-10)
553 reads
Use this script to generate BACKUP DATABASE scripts for selective or all databases during Instance or Database migration.
2014-12-31 (first published: 2014-12-10)
1,304 reads
This function is used to calculate the actual unit of conversion for energy.
2014-12-30 (first published: 2014-12-11)
725 reads
Always wanted to know the OS details? This function tells you everything (MSSQL 2008R2 and newer version only)
2014-12-29 (first published: 2014-12-06)
1,539 reads
2014-12-25 (first published: 2014-12-04)
1,122 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
hi , a new user wants to be able to add sql agent jobs...
WA:08218154393 Jl. Dr. Saharjo No.149 G-H, RT.5/RW.4, Manggarai Sel., Kec. Tebet, Kota Jakarta Selatan,...
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