Tuesday 23 November 2021

Concatination

Concatination is the process of joining character strings end-to-end.

select u.userid,hrms.FirstName+'('+hrms.EmployeeCode+')' as employee from [dbo].[User] u inner join hrmsemployee hrms on hrms.EmployeeID=u.employeeid

SELECT CAST(11 AS VARCHAR(10)) + CAST(33 AS VARCHAR(10)) +CAST(99 AS VARCHAR(10)) AS TrueResult             output 113399

SELECT 11+33+99 AS WrongResult output 143


select u.userid,concat(hrms.FirstName,'(',hrms.EmployeeCode,')') as employee from [dbo].[User] u inner join hrmsemployee hrms on hrms.EmployeeID=u.employeeid

SELECT CONCAT(11,33,99) AS Result output 113399


Tuesday 4 May 2021

Useful Learning Sites

www.primetechie.com

www.lynda.com 

www.udemy.com 

www.udacity.com 

www.coursera.org 

www.w3schools.com 

www.thenewboston.org 

www.programmr.com 

www.codeavengers.com 

www.codeschool.com 

www.learnstreet.com 

www.teamtreehouse.com 

www.sqlzoo.net 

www.codehs.com 

www.teamtreehouse.com 

www.html5rocks.com 

www.codepen.io 

www.sitepoint.com  

www.javatpoint.com 

www.cplusplus.com 

www.learncpp.com 

www.tutorialspoint.com 

www.cprogramming.com 

www.stackoverflow.com 

www.learncodethehardway.org 

www.bloc.io 

www.howtocode.io 

www.edx.org 

www.instructables.com 

www.developer.apple.com 

www.developer.android.com 

www.developers.google.com 

www.developer.mozilla.org 

www.msdn.microsoft.com 

www.dev.opera.com 

www.www.developphp.com 

www.quackit.com 

www.htmlite.com 

www.siteduzero.com 

www.dreamincode.net 

www.phpbuddy.com 

www.php.net 

www.microsoftvirtualacademy.com 

www.professormesser.com

www.techiegen.com

Useful Websites for Web Developers

Create beautiful Images of your Code 

Practice HTML/CSS with Projects

Frontend Tips & Tricks

Best YouTube Channels for Programming

FreeCodeCamp

ProgrammingWithMosh

CodeWithHarry

Telusko

Sentdex

Dateformats

 https://www.w3schools.com/sql/func_sqlserver_convert.asp