/* // 저장 프로시저 사용할때 // 반환 값 파라미터 var returnParam = new SqlParameter(); returnParam.Direction = ParameterDirection.ReturnValue; returnParam.SqlDbType = SqlDbType.Int; returnParam.ParameterName = "@RETURN_VALUE"; // 꼭 명시! cmd.Parameters.Add(returnParam); cmd.ExecuteNonQuery(); // 반환값 읽기 int _RTN = (int)cmd.Parameters["@RETURN_VALUE"].Value; */ // 저장 프로시저가 아니면 // SELECT 1, SELECT 3 값은 ExecuteScalar..
SELECT Category, -- Replace with your actual column name for category COUNT(*) AS Count, CAST(COUNT(*) * 100.0 / SUM(COUNT(*)) OVER () AS decimal(10,2)) AS Percentage FROM YourTable GROUP BY Category;Result-------------------------Category Count PercentageM 10 10.0W 90 90.0
Create Table SaveChat ( ChatDate Date , ChatVar varchar(20), ChatName varchar(50), ChatCount Integer, Constraint tb_product_group_PK Primary Key(ChatDate,ChatName) )------------------------------------------------------------------------------------INSERT INTO SaveChat (ChatDate, ChatVar, ChatName, ChatCount) VALUES (@ChatDate, @ChatVar, @ChatName, @ChatCount) ON CONFLICT(ChatDate, ChatName) D..

Error. An error occurred while processing your request. Request ID: Development Mode Swapping to the Development environment displays detailed information about the error that occurred. The Development environment shouldn't be enabled for deployed applications. It can result in displaying sensitive information from exceptions to end users. For local debugging, enable the Development environment ..
PatIndex('%[^0-9]%' 로 nums의 3자리가 int형인지 검사하고(참이면 3, 아니면 0) 자기 자신 db를 조인해서 일괄업데이트진행. ________________________________________________________________________________________ Update db set ClsNum == aa from db as A Join ( Select aa, ids from( Select nums as aa, ids from( Select PatIndex('%[^0-9]%', left(VarNums,3) ) as nums , * from db where len(VarNums)>3 ) as AB where aa = 3 ) as ABB ) AS B on A..

// 1. 연결된 ttyUSB Path 확인 usb 1-1.2 // usb 1-1.4 pi@Teon:~ $ dmesg | grep ttyUSB // 2. usb-serial rules 수정 pi@Teon:~ $ sudo nano /etc/udev/rules.d/10-usb-serial.rules SUBSYSTEM=="tty", ATTRS{idProduct}=="6001", ATTRS{idVendor}=="0403", ATTRS{devpath}=="1.2", SYMLINK+="ttyUSBa" SUBSYSTEM=="tty", ATTRS{idProduct}=="6001", ATTRS{idVendor}=="0403", ATTRS{devpath}=="1.4", SYMLINK+="ttyUSBb" // 3. 저장내용..
udevadm info /dev/ttyUSB0
sudo nano /etc/sdg/lxsession/LXDE-pi/autostart
- Total
- Today
- Yesterday
- 연산자 뒤에 피연산자가 없습니다.
- Xamarin.Ios Firebase Phone User Add
- 암호 마스터키
- Xamarin Firebase Phone User Add
- Xamarin.Ios Firebase Phone Auth
- WPF Excel Export Microsoft.Office.Interop 성능향상(열 기준으로 복사)
- WPF Scrollviewer in ScrollViwer
- Xamarin Firebase Phone Auth
- FileStream Add Byte
- WPF Datagrid Cell Value Change
- Label Text LineBreak in Xaml
- Xamarin SMS OTP Send
- ClickOnce 인증서 인증기간 변경
- GetCellContent CheckBox Value
- Windows IIS FTP 디렉토리 목록 오류
- C# LINQ Left join
- WPF Textbox
- 서버 수준의 URN 필터
- Xamarin.Ios Firebase Phone SMS OTP Send
- Microcharts
- SkiaSharp
- Entry '' has empty native path
- Linux SSH Multi Computer Join
- Xamarin reCAPTCHA
- c# Encrypt / Decrypt
- Xamarin.Forms
- Embeded 한글Font적용
- ssl_client_socket_impl.cc
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | ||
6 | 7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 | 19 |
20 | 21 | 22 | 23 | 24 | 25 | 26 |
27 | 28 | 29 | 30 | 31 |