My team mate Pi asked me today: how do you create a byte with the value 00000001 in SQL Server?
The answer is to create an integer representation of the byte’s value, and cast it to binary.
The output in Management Studio is: 0x01 (Management Studio outputs binary fields in Hex format). Hex 0x01 = Bits 0000001.
The Microsoft SQL Server Team has recently posted about one of the really exciting enhancements to SQL Server 2019 – Big Data Clusters
Tue., 10 Sep. 2019, 5:30 pm: So I assume the session title got your attention… Good! As databases get larger and organisations retain more data for business intelligence / data analytics purposes the — Read on www.meetup.com/en-AU/Sydney-SQL-Server-User-Group/events/261421144/ Tags: Career Development, Microsoft SQL Server, MSSQL, SQL Server, SQL User Group
A new home for the SQL Server engineering team to communicate important information about SQL Server with the community. We have migrated several SQL Server related blogs to this new home in the SQL Server TechCommunity. Click here for the new SQL Server Engineering Team blog. There’s also a list of links to some of their […]
