MD5 MD5 md5 = new MD5CryptoServiceProvider();md5.ComputeHash((ASCIIEncoding.ASCII.GetBytes(strValue)));byte[] byteResult = md5.Hash; StringBuilder sb = new StringBuilder(); for (int i = 0; i < byteResult.Length; i++){ sb.Append(byteResult[i].ToString("x2"));} return sb.ToString(); 더보기 How to Export Image column to file on MSSQL 1. Enable the extended stored procedures: sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'Ole Automation Procedures', 1; GO RECONFIGURE; GO 2. Use sp_OA stored procedures DECLARE @objStream INT DECLARE @imageBinary VARBINARY(MAX) DECLARE @filePath VARCHAR(8000) SELECT @imageBinary = img FROM Images WHERE ID = 1 SET @filePath = 'c:\img_1.jpg' EXEC sp_OACreate 'ADODB.Stre.. 더보기 SQL Server and system CPU usage history MSSQL 2005DECLARE @ts_now bigintSELECT @ts_now = cpu_ticks / CONVERT (float, cpu_ticks_in_ms) FROM sys.dm_os_sys_infoSELECT top 20 record_id, EventTime, CASE WHEN system_cpu_utilization_post_sp2 IS NOT NULL THEN system_cpu_utilization_post_sp2 ELSE system_cpu_utilization_pre_sp2 END AS system_cpu_utilization, CASE WHEN sql_cpu_utilization_post_sp2 IS NOT NULL THEN sql_cpu_utilization_post_sp2 EL.. 더보기 이전 1 2 3 4 ··· 55 다음