Recently I encountered a problem in a stored procedure that was caused by an unexpected result from the SQL Server ISNUMERIC() function. I was using SQL Server 2008 R2 but the issue has long been ...

DECLARE @server NVARCHAR(255) = '.' DECLARE @query NVARCHAR(MAX) = 'SELECT * FROM Win32_Processor' DECLARE @headers NVARCHAR(MAX) DECLARE @results XML SET @results ...

This is demo code how messages can be sent from Microsoft SQL Server (2005+) to a RabbitMQ message broker. The way it is implemented is by using SQLCLR, .NET running inside the SQL Server engine ...

T-SQL is great for database code, but writing procedural code in T-SQL has always been difficult. Invariably, your project includes a stored procedure or two, requiring some text parsing or complex ...

SQL Server 2005&'s new integrated Visual Studio features allow solution providers, who write lines of business applications, to be more productive by giving them faster access to data and more ...