The Four Tendencies
What’s in it for me? See how the Four Tendencies are reflected in the people around you. How do you respond to expectations? While this […]
Articles by hung-nb
SQL Server: Error converting data type varchar to numeric.
Convert varchar to decimal error 1 Add another column with required dataType. [sql] ALTER TABLE [table name] ADD [column name] decimal(10,2) NULL [/sql] Import all […]
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, […]
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]