GroupBy Clause - SQL Server vs MySQL
›
A GROUP BY Clause is used to group the data based on specific columns along with summary information. However there are some differences in ...
SQL Server Inner Join - Concepts and Best practices
›
In a database such as SQL Server, we create tables which are related to each other through a common column. For example, if we have to stor...
SQL Server Query Pagination
›
This article was authored by Praveen Dabade. In SQL Server 2012, Microsoft introduced a couple of T-SQL Enhancements. One of them is Query...
Shrink a Live SQL Server Database and Logs - Caveats and Best Practices
›
Updated on December 20th, 2017. If you have deleted a lot of data in the database and truncated some tables, probably you may want to shr...
3 comments:
SQL Server ISNULL() With Multi Column Names
›
Many a times we come across null values within tables in SQL Server. Null values are the values with no data; that means the data is missin...
1 comment:
SQL Server T-SQL DateDiff Example
›
How do we find the difference between two dates in SQL Server. Not just the difference in the number of days, but also number of weeks, mont...
SQL Server: Return Newly Inserted Row
›
Whenever you insert a new row in a SQL Server table that contains default values, you may want to return the newly inserted row to the use...
Calculate SQL Azure Database Size
›
I was looking out for a correct way to programmatically determine the size of a SQL Azure database. After searching many solutions, I finall...
1 comment:
Remove Non-Alphabet Characters from a String–SQL Server
›
Suppose you have a string that contains numbers and other special characters and you want to keep only alphabets and remove all the other ch...
Nested Case Statement in SQL Server
›
This article is a continuation of SQL Server CASE Statement and CASE WHEN Examples . Today we will learn about Nested Case Statement in SQ...
›
Home
View web version