In SQL Server, you can use PIVOT to convert multiple rows into columns to show a summarized result. I’ll show how using this method you can easily save the rows to columns converted data into a table ...
In SQL Server, you can use the DATENAME() function to get the week day for a given date. I’ll show you how to use this function to get first and last day of a given month or date in SQL Server. ...
You can use Excel as a database, as long as your requirements are limited. Create multiple sheets in your workbook, store various type data in the sheets and work with the data as and when required ...
In SQL Server, you can use the DATEADD() function to get last 3 months (or n months) records. I have used this function in one of my previous posts where I have shown how easily you can get previous ...
There are two simple methods in SQL Server to check weather a given Column Exists in a Table or not. This is important when you are trying to add a new column in a table dynamically, without knowing ...
You can easily escape a single quote in SQL Server by doubling it. Yes, it is that simple. Add two quotes (') instead of a single quote and SQL Server will store the single quote along the string in ...
The aggregate MIN() function in SQL Server is used to find the minimum or the smallest value of a column. It is a very commonly used built-in function in SQL Server. Now recently I came across ...
Here’s a list of top 5 SQL Server posts and articles that were viewed, shared and liked on encodedna.com. Some of the SQL Server posts in the list were pinned as “featured snippets” once or twice and ...
Here’s a simple SQL Server tip, I thought would be useful for beginners. Let us assume I have a Sales table with few records. Each row in the table has data such as total quantities sold, total price ...
Web developers using Asp.Net, commonly use the GridView control to display data in a tabular format. The GridView comes with many useful features, especially paging. Here in this post I’ll show you ...
