SQL stands for Structured Query Language. SQL lets us access and manipulate databases.
Change Collation for all Database Tables columns: Here in this article will see how we can modify the collation of our database tables column. In our previous article have explained how we can find the collation […]
SQL Server gets the last date of the month: Here in this article, we learn how to get the end date of any given month. Let assume one has the requirement to find start date […]
SQL Server Find Collation of Database: Here in this article we see how to find the collation of particular Database in SQL server 2008 r2. Finding Collation of SQL Server is very helpful when you […]
MS SQL Backup all databases: Here in this article will see how to take backup of all database from SQL Server step by step. From SQL Server Management Studio we can make our databases backup […]
SQL: Using Parentheses with And / OR condition is necessary with where clause to gives expected result
Are parentheses necessary in SQL: In this article will explain the difference between a simple SQL select query using with parentheses and using without parentheses one, and you will notice the different result of each […]