Mit

/* // 저장 프로시저 사용할때 // 반환 값 파라미터 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..

.Net 7 라즈베리파이 설치 wget -O - https://raw.githubusercontent.com/pjgpetecodes/dotnet7pi/master/install.sh | sudo bash 참고> pjgpetecodes/dotnet7pi: Install .NET 7 on a Raspberry Pi with a single line. (github.com)

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..

WHERE ( S_Day >= @s_Day and Not (S_Day= @s_Day and CONVERT(DATE, Stime) = @s_Day) ) : 금일자 이후 모든 날짜 중 S_Day가 오늘이고 Stime이 오늘인 날 제외

// 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