Sql

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 DataBase Table Columns.

SQL SERVER : How To Change Collation for all DataBase Table Columns.

 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 of database with a simple SQL Script in SQLSERVER 2008 R2. Here in this example, we set or alter collation all […]


by - Satinder singh

How to Find Last Date of Month in SQL Server [ EOMONTH ]

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]

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]

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

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

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

1 2