/* // 저장 프로시저 사용할때 // 반환 값 파라미터 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
- ssl_client_socket_impl.cc
- Windows IIS FTP 디렉토리 목록 오류
- Label Text LineBreak in Xaml
- c# Encrypt / Decrypt
- SkiaSharp
- Entry '' has empty native path
- Embeded 한글Font적용
- 암호 마스터키
- WPF Scrollviewer in ScrollViwer
- Xamarin Firebase Phone Auth
- 연산자 뒤에 피연산자가 없습니다.
- Linux SSH Multi Computer Join
- Xamarin.Ios Firebase Phone SMS OTP Send
- FileStream Add Byte
- Xamarin.Ios Firebase Phone Auth
- ClickOnce 인증서 인증기간 변경
- GetCellContent CheckBox Value
- Xamarin Firebase Phone User Add
- WPF Excel Export Microsoft.Office.Interop 성능향상(열 기준으로 복사)
- WPF Textbox
- Xamarin.Ios Firebase Phone User Add
- Microcharts
- Xamarin SMS OTP Send
- 서버 수준의 URN 필터
- WPF Datagrid Cell Value Change
- C# LINQ Left join
- Xamarin reCAPTCHA
- Xamarin.Forms
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 |