IT 썸네일형 리스트형 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.. 더보기 rapidshare file find "rapidshare.com/files" zip|rar|mp3|avi|mpg|mpeg|part1|html filename 더보기 Inport/Export Data from another database/file BULK INSERT MyTableName FROM 'C:\TargetFile.csv' WITH (FIELDTERMINATOR = ','); SELECT * INTO DestinationDB..MyDestinationTable FROM SourceDB..MySourceTable It will not copy constaints, defaults or indexes. The table created will not have a clustered index. Alternatively you could: INSERT INTO DestinationDB..MyDestinationTable SELECT * FROM SourceDB..MySourceTable 더보기 Regular Expression - Phone Number with country code ((00\d{1,3}-?\d{1,3}-\d{1,4})|(0\d{1,2}))-\d{3,4}-\d{4} (\(\d\d\d\))?\d{1,3}-\d\d-\d\d 더보기 [MS Sql] 여러 레코드를 하나의 문자열로 합치기 USE pubs Go CREATE FUNCTION dbo.ConcatAuthors(@State CHAR(2)) RETURNS VARCHAR(8000) AS BEGIN DECLARE @Output VARCHAR(8000) SET @Output = '' SELECT @Output = CASE @Output WHEN '' THEN au_lname ELSE @Output + ', ' + au_lname END FROM Authors WHERE State = @State ORDER BY au_lname RETURN @Output END GO 함수 사용 SELECT DISTINCT State, dbo.ConcatAuthors(State) FROM Authors ORDER BY State 너무 느리다 -.-;;;;;.. 더보기 이전 1 다음