SQL stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.
SQL SERVER : How To Change Collation for all Table Columns.
Change Collation for all 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 of database with a simple SQL Script in SQLSERVER. Here in this example, we set i.e alter collation all tables columns as SQL_Latin1_General_CP1_CI_AS […]by - Satinder singh
How to Find Last Date of Month in SQL Server [ EOMONTH ]
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 and end date of the current month in SQL Server. In short, we need to get First Day of the […]by - Satinder singh
Find collation of database [SQL SERVER]
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 need to change the Collation at the Database Level. Assume you have to join two different table from two different Database Server, […]by - Satinder singh
One SQL Script to take Backup of all DataBases [ MS SQL SERVER]
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 .i.e using user interface we can easily get the .bak file of our database, which we can restore later anywhere. […]by - Satinder singh
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 query. One day, my junior asked me one question why I am using parentheses ( brackets ) in most of […]by - Satinder singh
Get Time part from Datetime in MS SQL server
TIME PART FROM DATETIME: This article shows how to get only time part from DateTime in MS SQL Server. While development sometimes we need to take solely Time part from the whole Datetime. That is if the given date value is 2017-01-01 09:32:15.000 and here we want to fetch only time part for this given date […]by - Satinder singh