SQL Server: How to SELECT vertically/ horizontally?
name maths science english sex aaa 11 22 33 female bbb 44 55 66 female ccc 77 88 99 female Use UNPIVOT [sql] select u.Test2, […]
Software Development
Backup Database in Linux
Create bash file Create file Add execution permission Run bash file Set cron tab [js]sudo crontab -e[/js]And add the following line at the bottom of […]
Hosting – Ubuntu
Install XAMPP Change phpmyadmin root password Access PHPMyadmin control panel page Select “User Accounts” tab Select “Edit Privileges” at root user row Select “Change password” […]
SQL Server: Job – How to find jobs calling a specific stored proc?
[sql]SELECT j.name FROM msdb.dbo.sysjobs AS j WHERE EXISTS ( SELECT 1 FROM msdb.dbo.sysjobsteps AS s WHERE s.job_id = j.job_id AND s.command LIKE ‘%store_proc_name%’ ); [/sql]
Visual Studio: Package Management – How to install references from NuGet?
Access to “https://www.nuget.org/” Search package Install: Tools > NuGet Package manager > Package manager Console [sql]Install-Package PdfSharp -Version 1.50.4619-beta4c[/sql] Uninstall [sql]Uninstall-Package PdfSharp -Version 1.50.4619-beta4c[/sql]