Get Day, Month & Year Parts Separately from Date in Microsoft SQL Server
Sometime we need to get Day, Month or Year part only from the given date. We can get it using the DATEPART function. It has following syntax: Where datepart is …
Get Current Date & Time in Microsoft SQL Server
We often need current Date/Time in our queries. We can get it using SQL Server’s built in GETDATE() function. Here are some examples to demonstrate this concept: Select current Date/Time: …
Emmet: Your Secret Weapon for Faster and Cleaner Code
Emmet is a powerful tool that can drastically speed up your web development workflow. In the fast-paced world of web development, speed and efficiency are key. Writing repetitive HTML and …
Notepad++
Notepad++ is a free, powerful, and user-friendly text and source code editor for Windows. With its lightweight design and wide range of features, it has become one of the most …