SQL Server 101 – Get the Date part from DateTime
You can use the convert function in SQL Server to retrieve only the date part from the date time. How to get the Date part from DateTime variable in SQL Server ? Here’s a sample code snippet de...
Tag Archives: tricks
SQL Server 101 – Return the Current DateTime
If you want to return the current date time in SQL Server , the easiest way to do it is using the GETDATE() function. How to return the Current DateTime in SQL Server ? The GETDATE() function returns...
SQL Server 101 – How to add a column with a default value to exi...
There are times when you want to add an column with a default value to the existing table in SQL Server and you can easily do that with the DEFAULT keyword. How to add a column with a default value t...
SQL Server 101 – How to Delete Top N records ?
Assume that you have a table named “Employee” in MS SQL Server and you would like to delete the top 1000 rows from the table. You can use the SQL Query with the TOP (N) as option as shown...
GraphQL.NET 101 – What is GraphQL?
Problem You are new to GraphQL and would like to know more about GraphQL. Solution GraphQL is an open source data query language for API’s and a runtime for fulfilling queries with the existing...
How to Change Theme in Microsoft Azure Portal ?
There are times when you want to have a different style or theme for your Azure Portal. In this blog post , you will find out how to change the them in your Azure portal. How to Change Theme in Micro...
How to get the List of AD Groups that a user is member of using PowerS...
Assume that you have a userid which is part of Active Directory and you would like to get the list of all the active directory groups in which the specified user is a member of. You can do this easil...
How to disable the research task pane in Microsoft Excel?
In Microsoft Excel 2016 , when you press the Alt Key and simultaneously click a cell in the worksheet , a research pane would appear at the right hand side of the sheet. There are times when you woul...
How to wrap text using Wrap Text Command in Excel ?
Microsoft Excel provides the Wrap Text command that lets the users to quickly wrap long sentences and lets the users view the full content of the cell easily. How to wrap text using Wrap Text Command...