Meta Thinking, Meta Working
When running a standard check using VARCHAR(MAX) in MS-SQL Server, I get a "type mismatch" error. Distribute data standard inspection tool v1.34_20221215 that solved this error. Data standard inspection tool_2.1.Screen composition, 2.2.Standard inspection function – Productivity Skill (prodskill.com) The following comments were posted on this article. One....
Google Spreadsheet has a problem where leading spaces are removed when pasting text containing leading spaces. SQL statements that require indentation to be readable are often pasted into Google Spreadsheets, but this is a phenomenon in which all indented leading spaces are removed, resulting in poor readability. 1. Google Spreadsheets leading spaces are removed...
The Windows 10 logon screen image keeps changing automatically over time. Here's how to select an image you like from among the logon screen images, save it, and use it as your wallpaper. 1. Saving the Windows 10 logon screen image The Windows 10 logon image is saved in the following path....
I use a three-dimensional keyboard. I think the three-dimensional keyboard is the most effective keyboard for Korean input. Take a look at the advantages and disadvantages of three types, comparison of two types and keyboards, types of three types, Windows/MacOS/Linux input methods, and precautions for use. In 2001, I learned and started using the three-stroke final, and around 2010, I changed it to a three-stroke 390 keyboard and so far...
I remember my favorite development tool and language, Delphi, when I was working as a developer. It is a language that made it possible to study the fun and rewarding of coding and OOP in depth. It is a pity that it has not been used much recently and seems to be disappearing. The language I learned in the “Introduction to Programming” course in my freshman year at university...
This is a story about a font that can be read lightly. Classification according to the shape of the font and the width of the character, and the appropriate font for each use such as reports, manuals, coding, and blogs. I have been reading and writing many papers and documents while doing IT consulting for a long time. Creating fonts...
Devpia, a representative developer community in Korea, is discontinuing its service. (As of 2022-10-10) URL: http://devpia.com/ I once did development, and I received a lot of help from Devpia regarding development languages such as Visual C++, C#, and Java. To share that help, for about 3 months from June to September 2006, ORACLE, MS-SQL...
In the recent work using SSIS (SQL Server Integration Services), we look at a tool that extracts SQL from a simple SSIS package file for SQL analysis. You can check the execution method, source code, sql file, and examples of csv file output results. 1. Overview of SSIS and SSIS_Util 1.1. SSIS...
Let's take a look at the functions to find the number of UTF-8 bytes and characters in Sybase ASE DBMS. This function was created and used in a project that converts from Sybase ASE Non-Unicode encoding, EUC-KSC, to Unicode encoding, UTF-8. * UTF-8 encoding Reference: UTF-8 – Wikipedia, the encyclopedia of all of us (wikipedia.org) EUC-KSC converts columns declared as varchar(10) to UTF-8...
In this article, we briefly look at DBeaver, one of the tools that connects to the database, executes queries, and checks the results, and examines DBeaver dark theme, Excel download, and font settings. 1. Overview of DBeaver DBeaver is a general-purpose database query tool. These days, there are so many different databases...
English 
한국어 
简体中文 
日本語 
Deutsch 
Español