Dates and Times in SQL Server: T-SQL functions to get the current date and time
We have come on quite a journey so far. SQL Server and Azure SQL Database provide date and time data...
2018-04-25
391 reads
Born SQL with Randolph West
Dates and Times in SQL Server: the science of time redux
Last time, we began an in-depth look at how time is measured. This post continues our journey. If any of...
2018-04-18
488 reads
Dates and Times in SQL Server: the science of time
Now that we have covered the various date and time data types (see the post from last time) in SQL...
2018-04-11
858 reads
Speaking at SQLSaturday #710 in Edmonton on May 5th, 2018
I will be presenting twice at SQLSaturday #710 in Edmonton, on 5 May 2018. You can join me for two...
2018-04-04
282 reads
Dates and Times in SQL Server: DATETIMEOFFSET
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-28
707 reads
Dates and Times in SQL Server: DATETIME2
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-21
349 reads
Dates and Times in SQL Server: TIME
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-14
761 reads
T-SQL Tuesday #100: Looking Forward
The future, 100 months from now: It’s Monday, 6 July 2026. It’s been quite a week since SQL Server Update...
2018-03-13
292 reads
Dates and Times in SQL Server: DATE
This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...
2018-03-07
409 reads
Dates and Times in SQL Server: SMALLDATETIME
Last week I spoke about a world wary data type for storing dates and times in a single column, with...
2018-02-28
1,063 reads
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
BIT_COUNT II
Comments posted to this topic are about the item BIT_COUNT II
I Can't Make You Learn
Comments posted to this topic are about the item I Can't Make You Learn
Why Your SQL Permissions Disappeared
Comments posted to this topic are about the item Why Your SQL Permissions Disappeared
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers