Pi Day

Sometimes I want to have control over a SQL Server database, but always some connection blocks. We can use this 1 2USE MASTER; 3ALTER DATABASE MyDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE; BUT, sometime, we cannot do it! Well, we have this solution… 1 2SET NOCOUNT ON; 3DECLARE @ToKill AS NVARCHAR(max); 4SET...

Chaque fois que je dois créer une application du type console, c’est le même problème. Alors, je publie la version que je vais utiliser sur toutes mes applications. Effet, j’ai analysé plusieurs solutions, et détails techniques de chaque solution et j’ai fini pour choisir une solution publiée sur CodeProject. Ma...

Easy way to convert a generic objet to xml string and xml string to generic object. public static string Serialize<t>(T xml); public static void Deserialize<t>(ref T obj, string xml); 1 2/// <summary> 3/// Deserialize xml --> obj 4/// </summary> 5/// <typeparam name="T"></typeparam> 6/// <param name="obj"></param> 7///...

How convert a text to a Title text with TSQL. It’s “easy” solution. 1 2CREATE FUNCTION udf_TitleCase (@InputString VARCHAR(4000)) 3RETURNS VARCHAR(4000) 4AS 5BEGIN 6 DECLARE @Index INT 7 DECLARE @Char CHAR(1) 8 DECLARE @OutputString VARCHAR(255) 9 10 SET @OutputString = LOWER(@InputString) 11 SET @Index = 2 12 SET...

How can we send email by sql script ? To enable Database Mail XP 1 2USE msdb; 3GO 4EXEC sp_configure 'Database Mail XPs' 5GO 6RECONFIGURE 7GO 8EXEC sp_configure 'Database Mail XPs', 1 9GO 10RECONFIGURE 11GO 12EXEC sp_configure 'Database Mail XPs' 13GO To configure database mail 1 2USE msdb 3GO 4 5DECLARE @ProfileName...