Skip to main content

Answer: How do you create a byte with the value of 00000001 in SQL Server?

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. SELECT CAST(CAST(1 AS TINYINT) AS BINARY(1)) The output in Management Studio is: 0x01 (Management Studio outputs binary fields […]

Hey Yo! SQLCMD may truncate your XML!

While trying to use SQLCMD to produce an app.config file, I encountered problems with the output being truncated. The script was similar to: DECLARE @appconfig XML SET @appconfig = ‘<configuration></configuration>’ … Insert configuration nodes — Output the config SELECT @appconfig as ApplicationConfiguration The default options for SQLCMD produced output like: ApplicationConfiguration ————————- <configuration><connecti (the value […]

How to Connect to a SQL Server Compact Edition Database with Management Studio

How to Connect to a SQL Server Compact Edition Database with Management Studio

Open a new connection by choosing File menu -> Connect Object Explorer in SQL Server Management Studio. Change the Server Type to SQL Server Compact Edition. For Database file: put the full path to an existing SQL Server Compact Edition .sdf file; click the drop-down button, and select New Database or Browse to locate a […]

What I’m Reading 18 April 2007

International Considerations for Database and Database Engine Applications  http://msdn2.microsoft.com/en-us/library/ms190245.aspx Strategies for Partitioning Relation Data Warehouses in SQL Server http://www.microsoft.com/technet/prodtechnol/sql/2005/spdw.mspx Physical Database Storage Design http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx International Considerations for Notification Services http://msdn2.microsoft.com/en-us/library/ms172557.aspx How MSN Messenger and MSN Hotmail scales with SQL Server 2005 http://www.microsoft.com/technet/prodtechnol/sql/2005/scddrtng.mspx Scaling out SQL Server 2005 http://msdn2.microsoft.com/en-us/library/aa479364.aspx Database Mirroring FAQ http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirfaq.mspx Database Mirroring http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx […]