SQL Basic Archives - Technology with Vivek Johari

Script to find complete months between two given dates

July 10, 2015April 27, 2018 vivekjohariLeave a Comment

Complete months between two given dates Below script will help in finding the complete months within the 2 given dates. In the below script we takes below dates as exampleStartdate =2015-07-05 Enddate =2016-01-06 /**********************Script Start**************************/ IF (object_id(‘tempdb..#month’) is not null) DROP TABLE #month CREATE TABLE #month (id int identity(1,1),MonthStartDate DATETIME,MonthEndDate DATETIME) DECLARE @startdate AS DATETIME […]

Script to find the complete weeks within two given dates

July 10, 2015April 16, 2018 vivekjohari21 Comments

Complete weeks within two given dates Sometimes we need to find out the complete weeks within two given dates. Below script will help in finding the complete weeks within 2 given dates. In this script, I have used below dates as exampleStartdate=2015-04-12 Enddate=2015-06-10 SET DATEFORMAT YMD if (object_id(‘tempdb..#weekdays’) is not null) drop table #weekdays Declare […]

RIGHT() function in SQL Server

January 26, 2015October 28, 2018 vivekjohari30 Comments

SQL Server – RIGHT () function Right():- This function returns the specified number of characters from the Right part of the given character string. Syntax:- Select RIGHT ( character_expression , integer_expression ) For example, the below query will return two characters from the last. Select RIGHT(‘Vivek’,2) Result ek

LEFT() function in SQL Server

January 26, 2015October 28, 2018 vivekjohari31 Comments

LEFT() function in SQL Server Left() Function This function returns the specified number of characters from the left part of the given character string. Syntax Select LEFT ( character_expression , integer_expression )For example, the below query will return two characters from the beginning Select LEFT (‘Vivek’,2) Result Vi

Between function in SQL Server

January 26, 2015October 28, 2018 vivekjohariLeave a Comment

Between function in SQL Server This function is used to select the values within a specified range. These values can be of Int type or Date data type or Text data type. Syntax:- SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2 In this article, we are going to use the following table for […]

SQL SERVER – Data types

January 25, 2015April 27, 2018 vivekjohari32 Comments

Data types in SQL Server In relational database, we store data in tabular form where data is divided into columns. Each column has a name and a data type which shows what type of data is going to store in that column. Below are the data types which are mostly used in SQL server.CHARACTER(n) Character […]

SQL Server – Convert() function

January 24, 2015April 27, 2018 vivekjohari31 Comments

Convert () function in SQL Server Convert () function is used to convert an expression from one data type to another data typeSyntax for CONVERT function CONVERT ( data_type [ ( length ) ] , expression [ , style ] ) Convert functions is usually used with date/time data type to convert a date in different formats. Below examples will […]

Database Creation using SQL Sever Management Studio (SSMS)

August 17, 2014April 27, 2018 vivekjohari22 Comments

In the previous article (Database Creation using Create Database command), I explained the database creation using the Create database command. In this article, I am going to explain the steps of creation a database using SQL Sever Management Studio (SSMS) using SQL Server 2008 R2. These below database creation steps will be same for SQLServer […]

Database Creation using Create Database command

August 17, 2014April 27, 2018 vivekjohari31 Comments

In SQL Server, database can be created by 2 ways:- Using Create Database command Using SQL Sever Management Studio (SSMS). In this article, I am going to explain the database creation using the command CREATE DATABASE. Syntax for creating a database through Create database command is given below:- CREATE DATABASE ‘Database name’ ON PRIMARY […]

Group by…..Having Clause

January 31, 2010April 10, 2018 vivekjohari71 Comments

Group By:- Group By clauses is used to groups rows based on the distinct values of the specified columns. The syntax of the Group by clause is:- Select column1, column2, column3, aggregate_function(expression ) From TableName Where (condition) Group By Column1, column2, column3 For Example, suppose we have a […]