Web_Application/C# (50) 썸네일형 리스트형 [regex][mssql] INSERT | INSERT INTO expression /(INSERT+?(INTO|)\s+(.*?)|)SELECT\s+(.*?)\s*FROM\s+(.*?)\s*(WITH|)\(NOLOCK\)\s(WHERE\s(.*)\s*)?/g matches X - INSERT TPE_40C X - INSERT #TPE_40C O - INSERT TPE_40C SELECT C_COA FROM TPP_10C AS D WITH(NOLOCK) WHERE 1=1 AND C_COA = 1 GROUP BY C_COA O - INSERT INTO TPE_40C SELECT C_COA FROM TPP_10C AS D WITH(NOLOCK) WHERE 1=1 AND C_COA = 1 GROUP BY C_COA demo link https://regexr.com/44ndb [regex][mssql] CRATE TABLE expression /CREATE\s(TABLE)\s(#|@)+(.*?)\s\((.*)\)+(;|)/g matches O - CREATE TABLE #TPE_04C (C_COA CHAR(3)); O - CREATE TABLE #TFP_14D (C_UNT CHAR(3), C_COA CHAR(3), C_FINC CHAR(5), P_COL SMALLINT, A_PN MONEY) O - CREATE TABLE #TFP_14D1 (S_SORT INT, CN_COA VARCHAR(50), C_FINC CHAR(5), P_COL SMALLINT, A_PN MONEY) X - CREATE INDEX #XIE1TFP_14D1 ON #TFP_14D1 (C_FINC) demo link https://regexr.com/44.. [regex][mssql] CREATE INDEX expression /(CREATE)\s(INDEX)\s(#|@)+(.*?)\s(ON)\s(#|@)+(.*?)\((.*)\)+(;|)/g matches X - CREATE TABLE #TPE_04C (C_COA CHAR(3)) X - CREATE TABLE #TFP_14D (C_UNT CHAR(3), C_COA CHAR(3), C_FINC CHAR(5), P_COL SMALLINT, A_PN MONEY) X - CREATE TABLE #TFP_14D1 (S_SORT INT, CN_COA VARCHAR(50), C_FINC CHAR(5), P_COL SMALLINT, A_PN MONEY) O - CREATE INDEX #XIE1TFP_14D1 ON #TFP_14D1 (C_FINC) O - CREATE IN.. [regex][c#] new line expression /(\r\n|\r|\n)+/g matches RegExr was created by gskinner.com, and is proudly hosted by Media Temple. Edit the Expression & Text to see matches. Roll over matches or the expression for details. PCRE & Javascript flavors of RegEx are supported. The side bar includes a Cheatsheet, full Reference, and Help. You can also Save & Share with the Community, and view patterns you create or favor.. [mssql][winform][ado.net] SSMS 와 Application 에서 쿼리 실행 시간이 너무 많이 차이 날때 1.점검사항 - ado, ado.net 을 사용하는가? sql server 의 기본 설정은 SET ARITHABORT ON 이나 ADO, ADO.NET에서는 실행 구문의 함수에 따라 재설정이 되기도 함. SET ARITHABORT ON; {{실행쿼리}} - ssms 에서 느린가? 조인 조건 및 where 절 오류일 가능성이 높음. 참조 https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6e5353b9-4837-4022-a535-5408ed6f852a/stored-procedure-running-slow-in-adonet?forum=sqldataaccess https://www.mssqltips.com/sqlservertip/4318/sql-server-.. [fpspread][winform][c#] currency 고정 소숫점 표시 유/무 Currency > FixedPoint = false [winform][c#] console 창 안보이게 node.js 실행하기 private string NodeSqlFormatter(string sourceText) { Process p = new Process(); DirectoryInfo startUpPath = new DirectoryInfo(Application.StartupPath); string[] delimiter = { "\\{{경로구분자}}" }; //경로 구분자 string path = startUpPath.ToString(); string[] paths = path.Split(delimiter, System.StringSplitOptions.RemoveEmptyEntries); string filePath = string.Format(@"{0}{1}", paths[0], delimiter[0]); strin.. [fpspread][c#] vb CopyRowRange -> c#CopyRange vb6 http://help.grapecity.com/spread/Spread8/WebSiteHelp/funct147.html fpSpread1.CopyRowRange I& * Row_CNT& + 1, (I& + 1) * Row_CNT&, (I& + 1) * Row_CNT& + 1 c#.net http://helpcentral.componentone.com/NetHelp/SpreadNet6/WF/spwin-commethods.html sprList.Sheets[_sheetIndex].CopyRange(dataIndex * 4, 0, (dataIndex + 1) * 4, 0, dt.Rows.Count, sprList_Sheet1.ColumnHeader.Columns.Count, false); 이전 1 2 3 4 5 ··· 7 다음