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..
Platforms > Android > MainAppication 에서 //protected override MauiApp CreateMauiApp() => MauiProgram.CreateMauiApp(); protected override MauiApp CreateMauiApp() { // Remove Entry control underline Microsoft.Maui.Handlers.EntryHandler.Mapper.AppendToMapping("NoUnderline", (h, v) => { h.PlatformView.BackgroundTintList = Android.Content.Res.ColorStateList.ValueOf(Colors.Transparent.ToAndroid()); });..
![](http://i1.daumcdn.net/thumb/C148x148/?fname=https://blog.kakaocdn.net/dn/rKSpK/btssBr31pMU/XpHjUoZwt661gRANijYEB1/img.png)
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..
Platforms > Andorid > MainActivity.cs 에 작성. protected override void OnCreate(Bundle savedInstanceState) { Window.SetStatusBarColor(Android.Graphics.Color.Black); // 상단 Status Bar 색상 변경 Window.SetNavigationBarColor(Android.Graphics.Color.Black); // Navigation Bar 색상 변경 base.OnCreate(savedInstanceState); }
FCM 오류: Xamarin Forms: Targeting S+ (version 31 and above) requires that one of FLAG_IMMUTABLE or FLAG_MUTABLE be specified when creating a PendingIntent Nuget 설치: Xamarin.AndroidX.Lifecycle.LiveData Xamarin.AndroidX.Work.Runtime 변경전: var pendingIntent = PendingIntent.GetActivity(this, AdnroidNotification.NOTIFICATION_ID, intent, PendingIntentFlags.OneShot); 변경후: var pendingIntent = PendingInten..
- Total
- Today
- Yesterday
- Microcharts
- Label Text LineBreak in Xaml
- Xamarin.Ios Firebase Phone Auth
- GetCellContent CheckBox Value
- Embeded 한글Font적용
- WPF Textbox
- WPF Excel Export Microsoft.Office.Interop 성능향상(열 기준으로 복사)
- Xamarin.Ios Firebase Phone SMS OTP Send
- c# Encrypt / Decrypt
- Xamarin Firebase Phone User Add
- Linux SSH Multi Computer Join
- Entry '' has empty native path
- 연산자 뒤에 피연산자가 없습니다.
- ssl_client_socket_impl.cc
- Xamarin Firebase Phone Auth
- Xamarin reCAPTCHA
- Xamarin SMS OTP Send
- C# LINQ Left join
- Xamarin.Forms
- WPF Datagrid Cell Value Change
- Windows IIS FTP 디렉토리 목록 오류
- 서버 수준의 URN 필터
- ClickOnce 인증서 인증기간 변경
- FileStream Add Byte
- Xamarin.Ios Firebase Phone User Add
- WPF Scrollviewer in ScrollViwer
- SkiaSharp
- 암호 마스터키
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
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 |